# delete blob
**URL:** https://forum.servoy.com/t/delete-blob/1693
**Category:** Classic Servoy
**Created:** [April 12, 2004, 10:04pm UTC](https://forum.servoy.com/t/delete-blob/1693 "2004-04-12T22:04:51Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Harjo](https://forum.servoy.com/u/Harjo)
#### Post date: [April 12, 2004, 10:04pm UTC](https://forum.servoy.com/t/delete-blob/1693/1 "2004-04-12T22:04:51Z")
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?
---
### Author:  [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)
#### Post date: [April 13, 2004, 8:54am UTC](https://forum.servoy.com/t/delete-blob/1693/2 "2004-04-13T08:54:16Z")
Did you delete the record? or set the column to null?
---
### Author:  [@Harjo](https://forum.servoy.com/u/Harjo)
#### Post date: [April 13, 2004, 8:56am UTC](https://forum.servoy.com/t/delete-blob/1693/3 "2004-04-13T08:56:17Z")
I deleted the record!
---
### Author:  [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)
#### Post date: [April 13, 2004, 12:53pm UTC](https://forum.servoy.com/t/delete-blob/1693/4 "2004-04-13T12:53:45Z")
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.
---
### Author:  [@jcompagner](https://forum.servoy.com/u/jcompagner)
#### Post date: [April 13, 2004, 8:20pm UTC](https://forum.servoy.com/t/delete-blob/1693/5 "2004-04-13T20:20:27Z")
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..
---
### Author:  [@Harjo](https://forum.servoy.com/u/Harjo)
#### Post date: [April 13, 2004, 8:32pm UTC](https://forum.servoy.com/t/delete-blob/1693/6 "2004-04-13T20:32:54Z")
> 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](https://forum.servoy.com/uploads/short-url/sFOzBLtbogbNGyQzfE44PDhauch.servoy) (11.6 KB)