Subject Re: [IBO] What other programs really slow down IBO/Firebird Embedded?
Author Helen Borrie
At 07:12 AM 10/02/2010, you wrote:
>Rob:
>
>Thank you for the reply.
>
>This is a single user system (at this point) on a single lap top, no
>network access. The DB is local and accessed with the FB embedded
>version (2.1).
>My "users" are all single user, health practitioners spread over US and
>Europe, they are not connected to the same DB or on a network.
>
>Nonetheless, this particular user is using the slow process I mentioned
>with a set patient's record to methodically try out which loaded program
>causes the problem. So, I'm guessing that is the best way to proceed? We
>know that when it is slow it takes 11:15 minutes to finish, otherwise
>about 1:30.

Try changing the GCPolicy in firebird.conf from 'mixed' (the default) to 'background'. Note, though, that even if this improves things, it won't cure an inherent sticky garbage problem - you'll be back in the v.1.5 situation, where you might need to schedule sweeps every couple of days.

Helen