ADOexpress speed posting records

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

Article #4133

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

#4133

From: BHL
Date: Fri, 22 Mar 2002 07:02

15 lines
1102 bytes

Hallo

I am posting about 1000 records to an sql server over an internet connection
using this sequence:

..->Append();
..setting fields
..->Post();

Connection speed is isdn 64 kb/s, and it takes about 2 seconds for
each record.

Can anyone help me to increase spead of posting records?

bhl

Technical Details

Message-ID: <3c9ad717$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,a12015ca1a1d1b3b,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-03-21 23:09:08 PST
From: "BHL" <bhl@interconsult.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADOexpress speed posting records
Date: Fri, 22 Mar 2002 08:02:47 +0100
Lines: 17
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: 195.204.197.2
Message-ID: <3c9ad717$1_2@dnews>
X-Trace: dnews 1016780567 195.204.197.2 (21 Mar 2002 23:02:47 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!dnews