Run several SQL queries concurrently

Thomas W. Olsen

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Run several SQL queries concurrently

Q: We would like to run several SQL queries concurrently on the same
Oracle database(i.e. start one before first is finished). The only way
to do it is to start it in separate threads. Should we create session
for each thread? If yes, then why?

Regards Thomas.
Tho...@TeknoGuide.Dk
Denmark.

Derek Davidso

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Run several SQL queries concurrently

Thomas

Quote

> Should we create session
> for each thread?

Yes, absolutely.

Derek Davidson
Get a FREE copy of DK's Audit Components for Delphi from my web site:
http://freespace.{*word*269}.net/d.davidson
Now Includes INFOPOWER Derived components and a demo

(Remove the x to EMail me : der...@mksoft.com)

Other Threads

1. Run several SQL queries concurrently

2. Problems in SQL Server when opening several queries.

3. BDE error when running 2 app concurrently

4. : Cancel a running SQL query

5. Running SQL queries stored in Access Tables

6. Terminate a running SQL Query

7. Problems running parametrized query with LIKE operator against SQL server nvarchar datatype

8. Killing a long running MS SQL 6.5 query

9. Autoincrement fields starts to increment itself when a Local SQL query is run

10. Quick Reports with several queries