Re: ADO Threads and Connection Pooling
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 01/07/04
- Next message: Brian Bushay TeamB: "Re: DefaultExpression broken"
- Previous message: Brian Bushay TeamB: "Re: BetterAdo ,instead of AdoCommand,AdoStoredProc.."
- In reply to: Simon Hooper: "ADO Threads and Connection Pooling"
- Next in thread: Simon Hooper: "Re: ADO Threads and Connection Pooling"
- Reply: Simon Hooper: "Re: ADO Threads and Connection Pooling"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 06 Jan 2004 21:09:08 -0600
>What does the statement "ADO is thread safe" actually mean?
You can use ado in threads other than the main thread
>I want to create a multi-threaded data processing application. Probably
>main plus three threads, all accessing the same SQL Server database.
Even if the result is a slower application?
>
>Am I best to have one universal TADOConnection that all the threads use, or
>do I need a separate TADOConnection created in each thread.
Any components you use need to be created in the thread you use them in.
You can have a datamodule that you create an instance of for each thread.
>
>If I do need a TADOConnection per thread, how do I invoke connection
>pooling?
SQL server handles connection Pooling independent of using threads in your
application. Unless you have a very high demand database application making it
a multi threaded application will probably result in a slower application.
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: DefaultExpression broken"
- Previous message: Brian Bushay TeamB: "Re: BetterAdo ,instead of AdoCommand,AdoStoredProc.."
- In reply to: Simon Hooper: "ADO Threads and Connection Pooling"
- Next in thread: Simon Hooper: "Re: ADO Threads and Connection Pooling"
- Reply: Simon Hooper: "Re: ADO Threads and Connection Pooling"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
