kopaka wrote:

>
> 1.
> I have table where is very often more records (up to 100) inserted and
> deleted. Deleted records is garbage what will be removed by garbage
> collector when recods will be read.

It's a bit more complicated in v2.x SS. For example, the garbage
produced by a committed delete will be removed as soon as there are no
other interested transactions active.

> 2.
> When more records (in my case cca 5 milions) are deleted from table,
> then next time when garbage collection is run, it will take very much
> time. On my test db. I run for select count(*) from table and after 12
> hours I broke it without result.

Do you run it on v1.5? If so, this is a known issue which is addressed
in ODS11 of v2.0. How many indices do you have on that table? What is
they selectivities?

> 3.
> Now I am doing some test about speed between FB 1.5.2 and FB 2.0.3 and
> seems to me, that when I am repeating an action which involves table I
> spoke about it under point 1 (it's records are deleted and again
> inserted so garbage is growing in this table ) then FB 2 speed is
> constantly slowing - more garbage more slow, while under FB 1.5 not.
> Does anyone have some suggestion about it ?

Try setting GCPolicy to Background in firebird.conf of v2.0.


Dmitry