Board index » delphi » 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?

 
Loginov Eugen

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Run several SQL queries concurrently


Hi, Thomas!

The detailed solution of your problem is described on

http://www.borland.com/devsupport/delphi/ti_list/TI3005.html

Best regards,
                                        Loginov Eugene.

Moscow State University.

Quote
Thomas W. Olsen wrote:
> 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?

Loginov Eugen

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Run several SQL queries concurrently


Hi, Thomas!

The detailed solution of your problem is described on

http://www.borland.com/devsupport/delphi/ti_list/TI3005.html

Best regards,
                                        Loginov Eugene.

Moscow State University.

Quote
Thomas W. Olsen wrote:
> 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?

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