🚀 go-pugleaf

I found that if table has no indexes it can be filled without ballooning. If
table has index it seems that Access recalculate it every time new row is
inserted.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> ???????/???????? ?
???????? ?????????:
news:gunaalqrneguyvaxarg.hcop2v0.pminews@207.105.83.65...
> On Mon, 31 Mar 2003 18:33:35 +0400, Viatcheslav V. Vassiliev wrote:
>
> >You may try use ADO Recordset object without TCustomADODataSet wrapper.
Get
> >it with Recordset property of TADODataSet, TADOQuery, TADOTable etc. Use
> >AddNew method and pass field names and values as parameters to this
method,
> >do not call Update method. Use server-side cursor.
> >
> >Note that if database initially (before inserts) has empty space (for
> >example, some thousand rows was deleted before) this space will not be
> >reused.
>
> I'm already doing the import exactly like you describe, except that I have
> been calling Update().
>
> Starting with a 100MB file (320,000 records) that was just compacted, an
> import of about 93,000 records results in a 500MB+ file.
>
>
> --
>  - Mike
>
> Remove 'spambegone.net' and reverse to send e-mail.
>
>