da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Threading Procs

Forum List » NCOCI8 » General English

Darkstorm
User

Fresh Boarder

Posts: 1

Karma: 0

Threading Procs

Posted: 2000/07/10 19:15

I was wondering if anyone has used the Stored Proc component in a thread? I do allot of reports for different clients and some (due to massive data and ammount of data selected) of the reports can take quite a few minutes. I'd like to drop the proc off on its own thread so the user can continue using the program while the proc runs.

I did read that there was thread support in the components, I was wondering if anyone has tried and how well it worked.

Diman

Admin

Posts: 1495

Karma: 19

RE: Threading Procs

Posted: 2000/07/11 11:26

Hi !

NCOCI8 is really multythreaded. It will work correctly in next case:
- set TOCIDatabase.InitModes := [dmThreaded]
- you can mix access to TOCIDataSet from different threads, but only single thread must have access to component in each time. TOCIStoredProc is subclassed from TOCIDataSet.

Forum List » NCOCI8 » General English