Re: *Extremely* slow Next() (record scrolling) - Article 3395 - go-pugleaf

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

Article #3395

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

Re: Extremely slow Next() (record scrolling)

#3395

From: Arnie Mauer
Date: Wed, 11 Sep 2002 15:03

25 lines
1830 bytes

Hi Mike,
What do you mean by "scroll through".  Is this just a query->Next() ?

When we read a recordset straight through, I use the following params in the
TADOQuery:

CursorLocarion = clUseServer
CursorType = ctOpenForwardOnly
CacheSize = 100
LockType = ltUnspecified

With this setup, I can read 1,000,000 rows from an Oracle server across a
100 MBPS LAN in about 20 seconds.  Can you provide any additional info?

- Arnie

"Mike Ruskai" <spammoc.reirracten@begoneynnaht.net> wrote in message
news:gunaalargpneevrepbz.h298xv0.pminews@207.105.83.65...
> Using BCB6 and ADO (MDAC 2.7) to access data in an Access 2000 database.
>
> I have found that the Next() function of TADODataSet (or TADOQuery -
doesn't
> matter) is *extremely* time-consuming.

< snip >

Technical Details

Message-ID: <3d7f5c56$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <gunaalargpneevrepbz.h298xv0.pminews@207.105.83.65>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,655f624a2633119d,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-09-11 08:41:05 PST
From: "Arnie Mauer" <amauer@vrms.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <gunaalargpneevrepbz.h298xv0.pminews@207.105.83.65>
Subject: Re: *Extremely* slow Next() (record scrolling)
Date: Wed, 11 Sep 2002 11:03:59 -0400
Lines: 27
Organization: VRMS
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: 209.140.211.97
Message-ID: <3d7f5c56$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1031756886 209.140.211.97 (11 Sep 2002 08:08:06 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message