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.

On Mon, May 19, 2008 at 10:09 AM, dr_john_mp <dr.john@...> wrote:
> Server Version: LI-V2.1.0.17798 Firebird 2.1
>
> Loaded the above onto our main Linux server, following what appeared
> to be successful trials on a test server. We have about 30-40 users
> during the day some of whom may have several programs running each of
> which accesses the database.
>
> Have had continuing reports of programs running slow, and in some
> cases locking up. The client programs haven't changed, and we have an
> event set on the server to take the database offline once each night,
> take a backup and then restore it (effectively checks for errors and
> compresses the data) - non of which has changed since we were running 2.0.
>
> I did find a couple of clients that still had 1.5.x client software,
> but have since updated every user to 2.1 clients (must be an easier
> way to do that).
>
> Still appear to have the problem, but never, of course when I am around.
>
> Stepping through a program in Delphi I did notice that some UPDATE
> sql's were much slower than they used to be, especially on a large
> table (>100k entries)
>
> Anyone else seen this?
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>