Re: How to speed up ADO accesses

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

Article #3392

Back to borland.public.cppbuilder.database.ado Previous Next

#3392

From: Vassiliev V.V.
Date: Tue, 10 Sep 2002 10:39

26 lines
2059 bytes

What exactly do you need to speed up (fetch records, inserts, updates etc.).

Anyway the fastest way to work with MS SQL Server and MS Jet databases is
OLEDB Direct Components Suite (trial is available at
http://www.oledbdirect.com). It works with OLEDB interfaces and bypass ADO
level. For example, there is a sample that inserts 1 000 000 rows into MS
SQL Server table ($(OLEDB Direct)\Examples\SQLServer\1000000Rows\). On some
modern computers this can take 10 sec. (100 000 rows/sec.). These components
can work with any OLEDB provider.

Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to work with MS SQL Server and MS Jet databases.

"Roland" <neubert@wst-gmbh.de> �������/�������� � �������� ���������:
news:3d7cab54$1@newsgroups.borland.com...
>
> Hello,
>
> does anybody know some tricks to speed up ADO accesses on databases
containing more than 100000 items in it.
>
> regards
>
> Roland

Technical Details

Message-ID: <3d7dd159$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!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3d7cab54$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,dfeae4d7cb37acc2
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-09-10 05:36:11 PST
From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d7cab54$1@newsgroups.borland.com>
Subject: Re: How to speed up ADO accesses
Date: Tue, 10 Sep 2002 14:39:21 +0400
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 212.188.98.38
Message-ID: <3d7dd159$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1031655769 212.188.98.38 (10 Sep 2002 04:02:49 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message