I had a 20MB zip file in a blob
I wanted to delete this specific record, and it takes about 3 minutes, before Servoy had deleted the file. (on a 1,7 Centrino, 1GHZ RAM machine XP)
The strange thing is that my Sybase was 25MB and after I deleted the file, my Sybase database was 48MB and the log-file 20MB
Is this normal behaviour?
Did you delete the record? or set the column to null?
I deleted the record!
I’m not surprised about the file sizes. Transactional databases make a copy in the logfile before they delete so that you can always go back to a previous version in case you crash. The database itself is not cleaned up, the space is reserved for the future. You can use Sybase Central (or command line tool) to compact the file (please check the SQL Anywhere docs for details). I am a bit suprised about the fact that it is so slow, we’ll investigate that.
how do you delete that record?
Just in a form as the selected record?
Dit you show the blob column?
Because it seems that i first loads the complete blob and then deletes the record..
how do you delete that record?
the record is a table-locked-view an I just deleted it
Just in a form as the selected record?
Yes
Dit you show the blob column?
No
test.servoy (11.6 KB)