Article View: borland.public.cppbuilder.database.ado
Article #3315ADO Multitrheaded - Problem: Very Slow
From: Helcio Mayor
Date: Thu, 24 Oct 2002 13:55
Date: Thu, 24 Oct 2002 13:55
12 lines
1392 bytes
1392 bytes
Hi there. Description - A single ADOConnection created in the WinMain. I spawn threads (I serialize then, that is the second thread runs after the first returns and so on. Owing to the fact that the connection does not like more than on query at a time). Create Worker threads with ADOQuery on them (STA - I call CoInitialize(NULL) The problem is that when the second query on the second thread is very slow. Is that an STA - MTA - marshalling problem or I did not set the ADO properties right ? Thanks,
Technical Details
Message-ID:
<3db7fbeb$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,bc32055dedaf9567,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-10-24 07:52:05 PST From: "Helcio Mayor" <helciomayor@hotmail.com> Sender: "Helcio Mayor" <helciomayor@hotmail.com> Reply-To: "Helcio Mayor" <helciomayor@hotmail.com> Subject: ADO Multitrheaded - Problem: Very Slow Newsgroups: borland.public.cppbuilder.database.ado X-User-Info: 62.49.218.46 62.49.218.46 NNTP-Posting-Host: 207.105.83.65 Message-ID: <3db7fbeb$1@newsgroups.borland.com> Date: 24 Oct 2002 06:55:55 -0700 X-Trace: newsgroups.borland.com 1035467755 207.105.83.65 (24 Oct 2002 06:55:55 -0700) Lines: 13 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail