SLOW insert speeds for access database

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

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Vladimir Tue, 21 Nov 2000 12:25

#6024

Author: Vladimir
Date: Tue, 21 Nov 2000 12:25

8 lines
1088 bytes

i'm using BCB5 with ADO to use a access database.
im using ADOQuery to select, insert, update, etc..
this is just extremely SLOW, taking about 1 second just
to insert a row. inserting over 100 rows is just not feasable

any solutions to speed up this connection?

thanks

Re: SLOW insert speeds for access database

#6029

Author: B Angus
Date: Wed, 22 Nov 2000 22:26

22 lines
1418 bytes

Just a guess. Try making sure marshall modified only is set. If you marshall
all then the entire table gets sent and re-read on each updated row.
"Vladimir" <darkice@mailbox.co.za> wrote in message news:3a1a6874_2@dnews...
> i'm using BCB5 with ADO to use a access database.
> im using ADOQuery to select, insert, update, etc..
> this is just extremely SLOW, taking about 1 second just
> to insert a row. inserting over 100 rows is just not feasable
>
> any solutions to speed up this connection?
>
> thanks
>
>
>
>
>
>
>
>
>
>
>

Re: SLOW insert speeds for access database

#6032

Author: Vladimir
Date: Thu, 23 Nov 2000 09:07

8 lines
1065 bytes

nope, still slow as hell, really unacceptable.
thanks for your input though.


B Angus wrote in message <3a1c4974_1@dnews>...
>Just a guess. Try making sure marshall modified only is set. If you
marshall
>all then the entire table gets sent and re-read on each updated row.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads