Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 3 of 3 total |
Blob File Size |
Mon, Jan 30 2006 7:34 AM | Permanent Link |
Pete Hollyer | I have a table that holds pictures as datastreams into a Blob field. Initially I loaded up 10 or 15 - 2MB photos...then I deleted them and converted
them to JPG files reducing their size dramatically....but the BLB file did not change in size...except to grow bigger even though the photos were reduced..... Why? and how can I force the BLB file to reset itself? Pete |
Mon, Jan 30 2006 7:45 AM | Permanent Link |
Pete Hollyer | Okay Two things. First I realize I put this thread in the wrong path..Second I found my own answer...Optimize the file...but in doing so it created a
COPY of the original file (extension .bbk) and then I presume re-created the .blb)...so when finished I had to delete the .bbk and all was okay. The question now is can this be done via code using the ODBC driver? |
Mon, Jan 30 2006 7:57 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Pete,
<< Okay Two things. First I realize I put this thread in the wrong path..Second I found my own answer...Optimize the file...but in doing so it created a COPY of the original file (extension .bbk) and then I presume re-created the .blb)...so when finished I had to delete the .bbk and all was okay. The question now is can this be done via code using the ODBC driver? >> Use the OPTIMIZE TABLE SQL statement: http://www.elevatesoft.com/dbisam4d5_optimize_table_statement.htm after the deletions. Use the NOBACKUP clause to prevent the DBK, IBK, and BBK files from being created. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |