Article View: borland.public.cppbuilder.database.ado
Article #4933ADO slower than BDE!!?
From: Farrokh Ghani Zadegan
Date: Sat, 01 Sep 2001 19:55
Date: Sat, 01 Sep 2001 19:55
18 lines
1707 bytes
1707 bytes
Hi, I made a WinNT service with BCB5 and used a ServerSocket and some BDE components in it. It worked well on Win2000 Advanced Server but didn't start on WinNT 4 SP6a. I bypassed this problem by replacing the BDE components with their ADO counterparts. After doing this, the service started and worked well but a new problem arose: What took BDE, 20 seconds to finish, takes ADO 14 minutes!!! Since I believe it's not ADO's problem, I explain more about it: This job that takes ADO so long to do, is simply making the filtered property of a table true and false for about 600 hundred times, and the filter itself is a very simple (Fieldname=value) statement. The database itself is an MDB file and I've used System DSN in my ADO connection- which is the same thing used when I used BDE components. Please help me if you have any experience in this field. Regards, Farrokh
Technical Details
Message-ID:
<3b910b75_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!howland.erols.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,f5b85ddade8637c4,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-09-01 09:31:29 PST From: "Farrokh Ghani Zadegan" <fghz@toosashena.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: ADO slower than BDE!!? Date: Sat, 1 Sep 2001 20:55:39 +0100 Lines: 20 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 NNTP-Posting-Host: 213.155.40.3 Message-ID: <3b910b75_1@dnews> X-Trace: dnews 999361397 213.155.40.3 (1 Sep 2001 09:23:17 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!howland.erols.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews