Close connection between calls

andy1234567 · #1 (**permalink**) 12-14-07, 10:58

Hi

Say that you have an application that makes a couple of calls to the same database (insert, uppdate and delete). Do I need to close the connection between every call or can I make them over the same connection?

I know that it is possible but cloud there be an issue in doing so?

gvee · #2 (**permalink**) 12-18-07, 17:34

The general rule of thumb is: close connections as soon as you can.

andy1234567 · #3 (**permalink**) 12-19-07, 04:04

Yes, but if I’m going to transfer say 100 rows from one table to another that’s 100 connect and 100 close. It would be better if i cloud use the same connection, it would use less resources. But if in doing so it creates error of some sort than i must close it for every insert.

Anyone?

gvee · #4 (**permalink**) 12-19-07, 08:20

You could move 100 rows from 1 table to another in one command...

Post yourQL/code

andy1234567 · #5 (**permalink**) 12-20-07, 03:18

How can i do that?

gvee · #6 (**permalink**) 12-20-07, 07:03

This should have read

Quote:

Originally Posted by georgev

Post yourQL/code

Post your SQL/code

Basically, I reckon you're using the following

Code:

INSERT INTO tableName(field1, field2) VALUES (value1, value2)

Which means you can only do one line at a time.

There is a lovely method you can use when transferring data from one table to another which goes a little something like this:

Code:

INSERT INTO tableName(field1, field2)
  SELECT otherTable.field1
       , otherTable.field2
  FROM   otherTable
  <optional where clause(s) etc>

andy1234567 · #7 (**permalink**) 12-20-07, 09:08

Thanks! ill try that!

Internet Services

Web Development

Digital Marketing

Consumer Tech