Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Increasing of file size when rebuilding indexes |
Tue, Jan 8 2008 6:47 AM | Permanent Link |
"Burkhard Schneider" | 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 |
Tue, Jan 8 2008 7:14 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Burkhard
What happens if you do an optimise afterwards? Roy Lambert |
Tue, Jan 8 2008 9:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Jan 9 2008 4:08 AM | Permanent Link |
"Burkhard Schneider" | "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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |