Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Compressing a sparsely populated file |
Thu, May 24 2007 9:14 AM | Permanent Link |
Jerry Blumenthal | I believe that deleting a record from a dbisam table does not make the
file any smaller. After deleting some 40% of the records in a table, is there an easy way to compress the file? Or else perhaps I should just use table; opentable create duplicate file old.first while not eof old do begin copy record from old to new next; end; delete old rename new Something like that? Jerry |
Thu, May 24 2007 9:31 AM | Permanent Link |
"Robert" | "Jerry Blumenthal" <jerry@blumenthalsoftware.com> wrote in message news:B364C7E8-0FE1-4D1B-8123-4C8986BA2FB9@news.elevatesoft.com... >I believe that deleting a record from a dbisam table does not make the file >any smaller. After deleting some 40% of the records in a table, is there >an easy way to compress the file? > Anything that will rebuild the data portion such as Optimize or repair. Robert |
Thu, May 24 2007 5:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< Anything that will rebuild the data portion such as Optimize or repair. >> Clarification: RepairTable won't compress the table and will leave the deleted records "as-is", but Optimize will since it causes the table to be copied into a new version, minus the deleted records. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |