Work with database is very slow

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

2 messages

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

2 total messages Started by John Wed, 08 Nov 2000 18:24

#6049

Author: John
Date: Wed, 08 Nov 2000 18:24

12 lines
1280 bytes

Hi,

I would like to use an MS ACCESS database with ADO. My program works, but
very very slow. It means for example 2 minutes to open the database or find
a record in it. With this speed I can not do anything.
The database has got 2 tables, each has about 100.000 records and the whole
database is about 23 Mb.
If I use Visual C++ or dBase files with BDE than it works fine and very
fast, but the dBase file is about 600 Mb and it's too big.

Thanks,
John

Re: Work with database is very slow

#6053

Author: B Angus
Date: Thu, 09 Nov 2000 01:22

21 lines
1567 bytes

The slow load is probably because client-side cursor is being used try
server-side. Good luck
"John" <prop70@swi.hu> wrote in message
news:8uc5se$e0m2@bornews.inprise.com...
> Hi,
>
> I would like to use an MS ACCESS database with ADO. My program works, but
> very very slow. It means for example 2 minutes to open the database or
find
> a record in it. With this speed I can not do anything.
> The database has got 2 tables, each has about 100.000 records and the
whole
> database is about 23 Mb.
> If I use Visual C++ or dBase files with BDE than it works fine and very
> fast, but the dBase file is about 600 Mb and it's too big.
>
> Thanks,
> John
>
>
>

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