🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4933

ADO slower than BDE!!?

#4933
From: Farrokh Ghani Zadegan
Date: Sat, 01 Sep 2001 19:55
18 lines
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!dnews

Show 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