[firebird-support] Database Size Is Not Reducing

Dear All, I am using Firebird 2.5 database. I have a table that has column of type Blob field, this table also contains some other columns. The issue is, I had total 78,000 records in this table. What I did is as every record was containing image in it, I then ran an update query and set Null va

Re: [firebird-support] Database Size Is Not Reducing

> On Apr 6, 2015, at 9:08 AM, Vishal Tiwari vishuals...@yahoo.co.in > [firebird-support] wrote: > > I am using Firebird 2.5 database. what operating system? Cheers, Ann

Re: [firebird-support] Database Size Is Not Reducing

> On Apr 6, 2015, at 9:08 AM, Vishal Tiwari vishuals...@yahoo.co.in > [firebird-support] wrote: > > I am using Firebird 2.5 database. I have a table that has column of type > Blob field, this table also contains some other columns. > > The issue is, I had total 78,000 records in this table.

RE: [firebird-support] Database Size Is Not Reducing

On Apr 6, 2015, at 9:08 AM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] mailto:firebird-support@yahoogroups.com>> wrote: I am using Firebird 2.5 database. what operating system? Also, what page size? How big (on average) was the size of the BLOB

Re: [firebird-support] Database Size Is Not Reducing

Operating system I am using is Windows 7 With Best Regards. Vishal

Re: [firebird-support] Database Size Is Not Reducing

Then what could be the best way to reduce the database size? All suggestions are appreciated. With Best Regards. Vishal

Re: [firebird-support] Database Size Is Not Reducing

On 07.04.2015 08:16, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > > > Then what could be the best way to reduce the database size? > > All suggestions are appreciated. Hej Vishal played around a little bit, unable to reproduce your problem. Even after setting some blobfi