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

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

Jeff


Try the OPTIMIZE TABLE sql command

Roy Lambert

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]

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