Subject Re: [firebird-support] Re: Basic tests shows very poor performance
Author grostoon
Fine Pavel, so my test was not that foolish. It at least shows me that FB2 has some good improvements over FB1.5 no ?

Thank you,


Pavel Cisar <pcisar@...> wrote:
grostoon wrote:
> Hi Pavel,
> Ok, I understand that garbage collection has work to do but : - why
> does it takes so much time for just 50Mo database file ? - why does
> FB2.0 give the result in a few seconds ???

FB 2.0 has new, reworked index structure that handles GC in indices with
a lot of duplicates more efficient. It has also improved GC strategy
and GC thread scheduling (but that apply only to Super Server, Classic
still uses cooperative GC only, so if you have tested Classic, it all
goes to new index structure). See 2.0 release notes for details.

> So garbage collection is the sole problem, may I have much better
> times if I set the sweep interval to 0 ?

No, sweep has nothing to do with this.

> BTW, I'm using isql with direct access to the database file (i.e I'm
> not using the fb_inet_server but direct connect
> '/home/toon/fbtest.fdb'). Does this make a difference ?


best regards
Pavel Cisar


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Technical support Computer technical support Compaq computer technical support Compaq technical support Hewlett packard technical support Microsoft technical support


Visit your group "firebird-support" on the web.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.

[Non-text portions of this message have been removed]