|Subject||RE: [firebird-support] Re: Database Size problem?? Please Help|
>2 more comments:
> Thank you for the quick reply..^_^
> But is there any way I can shink the db(other than back and restore
> it) or force it to reuse the free space?
> My real problem is that my program have do a lot of calculation and I
> use db as a drawing borad. If I use the ordinary harddisk to run it,
> then it will take about 2~3 week to finish one cycle of pattern
> analyzing, which is too slow. So I put the database file on a
> ramdisk,can refer to http://www.superspeed.com/servers/ramdisk.php.
> It really speed it up, but just eat up too much memory.
> Is gfix -sweep can use here? I try it, but seens no effect at all(may
> be is my misunderstanding the use of it).
> Best Reguard
1. if your cycle is more like insert, commit, delete, commit as opposed to
insert 1000000, commit delete 1000000 commit, then you may get less disk
space being used since there is the opportunity for the server to re-use
space freed byt he previous delete.
2. if you used the non-transactional vesion of MySQL, then at elast this
file system storage would never bloat, a deleted record is gone completely
when you delete it.