Hi,

I noticed that everytime I rebuild my indexes the file size the idx-file
increases by about 100 kB.

I use this code:

   DeleteAllIndexes;
   AddIndex('', 'ID', [ixPrimary, ixUnique]);
   AddIndex('INrMonatPrjTeillst', 'NR;MONAT;PROJ_NR;TEILLEIST');
   AddIndex('INr', 'NR');
   AddIndex('IKosten', 'KOSTEN');
   AddIndex('IPrjNr', 'PROJ_NR');
   AddIndex('IMonat', 'MONAT');

The Table has 6249 records.

Does this have a specific reason? Is there anything I can do against it?

DBISAM 4.25 C/S, Delphi 2007

regards
Burkhard Schneider

Burkhard


What happens if you do an optimise afterwards?

Roy Lambert

Burkhard,

<< I noticed that everytime I rebuild my indexes the file size the idx-file
increases by about 100 kB. >>

This is possible due to the way the indexes are rebuilt.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Roy Lambert" schrieb:

> What happens if you do an optimise afterwards?

Then the size shrinks to it's original value again. OK, I can live with
that.

regards
Burkhard Schneider