Opening multiple connections

[cjac]

Hi, is it necessary to open multiple connections if you have an application that can run 2 or more concurrent SQL's or will the one connection be able to handle this? The database that is being queried/updated is Oracle8i.
Ta.
C

 

[Spellman]

If you mean can you run multiple SQL statements off of the one Connection then the answer is yes. No problems.

Mark

The key to immortality is to make a big impression in this life!!

 

[cjac]

So, there would be no reason to open a new conection object in a seperate module if a connection was already opened at application login time, ie. Form1 opens from login and establishes a connection to Oracle. The user then triggers queries and updates from this form but can also simaltaneously launch Form2 which then triggers a different batch of SQL's and transaction processing. Obviously both SQL's are on the same DB. Would there be any performance gains in opening a new connection considering the above?

Thanks,
C

 

[Joe46]

My guess is it would take a performance hit since you would be maintaining more than one connection.