🚀 go-pugleaf

I've been trying to create a fast connection to a local MS Access database
using ADO components in BCB5. When inserting records into a very small test
db for insertion speed measurement, I got 17 seconds for 1000 records using
ADO-Jet 4.0 to with MS Access. Comparing to 0.7 seconds with IBX and IB6
MSAccess seems pretty lousy. Am I doing something wrong or is it reality?

Vassiliev, I tried to use your components as well, but didn't manage to
create a connection (jet4-MS Access) due to an "authorisation problem" which
I didn't understand.

Thanks for any help on using MS Access as dircectly as possible and as fast
as possible.

regards,
Markus



"Vassiliev V.V." <vv_vas@iname.com> wrote in message
news:3c2e658b_1@dnews...
> Try OLEDB Direct at http://www.oledbdirect.com. It uses OLEDB directly,
> without ADO. I added 1 million rows at 1 minute 5 seconds on PII-300 on
SQL
> Server with these components.
>
> Vassiliev V.V.
>
>
> "Avex" <I@dont.like.spammar> ???????/???????? ? ???????? ?????????:
> news:3c1eb21f_1@dnews...
> > Hi all,
> >
> > I have a large records , I need to post them into db,
> > but it needs long time to such a thing. Is there a
> > way to speed up ? My codes are as below:
> > I use ADO.
> >
> > for (i=0;i<9800000;i++)
> > {
> > Table1->Append();
> > Table1->FieldByName("f1")->AsString = f1[i];
> > ........................................................................
> > Table1->FieldByName("fn")->AsString = fn[i];
> > Table1->Post();
> > }
> >
>
>