Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
File too big |
Tue, Sep 5 2017 2:52 PM | Permanent Link |
Jeff Newlin Lightspeed | I have a table called "ERA" that has an associated BLB file. This BLB file is quite large (2.2 gig) .... This is the directory listing :
2,212,510,720 Era.EDBBlb 263,057,408 Era.EDBBlb.Old 8,908,800 Era.EDBIdx 136 Era.EDBIdx.Old 50,929,552 Era.EDBTbl 10,464,992 Era.EDBTbl.Old I cannot seem to store new records in this table and I suspect it is because of the large file size of the BLB file. I tried deleting records using the SQL : DELETE FROM Era WHERE Somedate < DATE '2011-01-01' This did successfully delete the records but there no change in any of the file sizes. I then tried using the command REPAIR TABLE Era thinking that my deleted records would be removed from the table. Again, no change in the file size. Is there a way to purge my table of deleted records and bring these file sizes down (or at least the BLB file)? Thank! Jeff |
Tue, Sep 5 2017 11:51 PM | Permanent Link |
Jeff Newlin Lightspeed | It turned out that the filesize was not my problem. But I am still curious if it's possible to purge records to decrease the file size?
Thanks! Jeff Jeff Newlin wrote: I have a table called "ERA" that has an associated BLB file. This BLB file is quite large (2.2 gig) .... This is the directory listing : 2,212,510,720 Era.EDBBlb 263,057,408 Era.EDBBlb.Old 8,908,800 Era.EDBIdx 136 Era.EDBIdx.Old 50,929,552 Era.EDBTbl 10,464,992 Era.EDBTbl.Old I cannot seem to store new records in this table and I suspect it is because of the large file size of the BLB file. I tried deleting records using the SQL : DELETE FROM Era WHERE Somedate < DATE '2011-01-01' This did successfully delete the records but there no change in any of the file sizes. I then tried using the command REPAIR TABLE Era thinking that my deleted records would be removed from the table. Again, no change in the file size. Is there a way to purge my table of deleted records and bring these file sizes down (or at least the BLB file)? Thank! Jeff |
Wed, Sep 6 2017 3:29 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Jeff
Try the OPTIMIZE TABLE sql command Roy Lambert |
Wed, Sep 6 2017 11:07 AM | Permanent Link |
Fernando Dias Team Elevate | Jeff,
Roy is right, OPTIMIZE TABLE will compact the blob file, as well as other optimizations. Here is what it does: https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=OPTIMIZE_TABLE -- Fernando Dias [Team Elevate] |
Wed, Sep 6 2017 11:38 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jeff,
<< Is there a way to purge my table of deleted records and bring these file sizes down (or at least the BLB file)? >> As mentioned, what you want is the OPTIMIZE TABLE SQL statement. However, you don't *need* to do so if you just enable large file support in ElevateDB. You can find out more about this here: https://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=rsdelphiwin32&version=10T&topic=Configuring_Starting_Engine under "Large File Support". For the ElevateDB Server, the settings information is here: https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Starting_Configuring_Server under "Configuration Reference". Tim Young Elevate Software www.elevatesoft.com |
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 |