Dataset.-Querys are slow ?

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

Article #1384

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

#1384

From: Andr?
Date: Mon, 02 Aug 2004 12:47

22 lines
1594 bytes

Hi there !
Well me and my colegues had some problems with query and datatransfer
speed. We used the TADOConnection, TADODataset, etc.. objects.

Import and export routines now used the TDataSet with select querys in
'for' and 'while' loops. This loops are reading data from other DBs
like Access-MDB or other SQL-Server computers while transforming and
packing them back to other tables (well, this is a slow variant of DTS
but is much more flexible).

So my problem: my client computer has a usage rate of about ~20
percent, while the SQL-Server still writing my data has a rate of ~10
percent ! The network utilization leads from 50 to 100 kilobytes per
second !

So I think: why isn�t it working faster ? There had to be a
"wait"-state swallowing all capacity...

Do you have such behaviors, too ?

regards,
Andr�

Technical Details

Message-ID: <611223d.0408020447.1026ccc1@posting.google.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews2.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,be99ea87a042d9a,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews2.google.com!not-for-mail
From: andre.hugenroth@takko.de (Andr?)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Dataset.-Querys are slow ?
Date: 2 Aug 2004 05:47:23 -0700
Organization: http://groups.google.com
Lines: 22
Message-ID: <611223d.0408020447.1026ccc1@posting.google.com>
NNTP-Posting-Host: 212.101.204.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1091450844 30077 127.0.0.1 (2 Aug 2004 12:47:24 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 2 Aug 2004 12:47:24 +0000 (UTC)