🚀 go-pugleaf

Put the ADO Dataset (Recordset) in batch update mode, make all changes and
then send the changes all in one go... (Set LockType to ltBatchOptimistic
and
call UpdateBatch(), not exactly sure whether a specific cursor type is
needed...
most likely local static or local keyset...)

Also there's no need to call Post after every Append() as Append by itself
calls
CheckBrowseMode() at its start which then calls Post() if needed. So Only
one post
is needed after data has been added... Also I think UpdateBatch() also calls
CheckBrowseMode() so it could be that no calls to Post are neeeded...

HTH,
    Jurko

P.S. If you try this out please post the if the time needed has decreased
and if
so then by how much. Thanks...

"BHL" <bhl@interconsult.com> wrote in message news:3c9ad717$1_2@dnews...
> 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
>
>