Subject Re: Firebird 2.1 slow/lock-up
Author dr_john_mp
Thanks for this, no problems since setting the async property.

Interesting that the default is forced writes. Since the setting is
on a per-database level I assume that any future updates will maintain
the existing setting; unlike the feature/bug in the linux install
program which TAR's up all of the firebird directory and then installs
the new version with new/blank database and config files, so you have
to manually copy back the originals to get your users back.


--- In firebird-support@yahoogroups.com, "Fabiano Bonin" <fabiano@...>
wrote:
>
> Yes, i had a similar problem when i upgraded to 2.0.4, but the reason
> is that forced writes never worked on Linux before due to a Linux bug,
> and now it works on 2.0.4 and 2.1. So if your database had forced
> writes on (gfix -write sync <database>), the performance impact is
> probably caused by this.
>
> You can try to disable forced writes to check (gfix -write async
<database>).
>
> Regards,
>
> Fabiano.
>
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>