Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: no search for forums?
no search for forums?
Posted: 2007/08/23 09:15
 
yes I am looking for some info on multi-threading your anyDAC component and cannot find anyway to search the support forums.

This is very odd...perhaps I am missing something, but support forums should have a search feature, don't you think?

if I missed it, accept my apoligy, but if not, can't you add a google search widget to index your site?

- mark
Re:no search for forums?
Posted: 2007/08/23 09:43
 
Hello

Ok, will check.

Multythreading rules with AnyDAC are simple:
1) if you need to run queries in parallel, then you need separate connections for each thread;
2) but if you will serialize query executions in different threads, then you can use single connection in multiple threads. But that will be not simple or worth. So, rather go by (1).

Regards,
Dmitry
Re:no search for forums?
Posted: 2007/08/23 09:47
 
1) if you need to run queries in parallel, then you need separate connections for each thread;

Ok..can try...so I will have to programatically create a TADConnection object and a TADQuery object, and assign the correct params in each, and these can share the cursor and physDriver components?

again, thxs.
- mark
Re:no search for forums?
Posted: 2007/08/23 09:59
 
Cursor - no. Each query creates own cursor.
Driver - yes.

If you will have a lot of threads, then you can consider to use pooling. For that set Pooled=True for connection definition.