Subject Re: [firebird-support] Scale or tune firebird?
Author Ann W. Harrison
At 01:01 AM 11/10/2004, Faisal Abdullah wrote:

>Hi all,
>I have an application *really* bad in design, which causes *very*
>sluggish performance,

What have you done to identify the cause of the problem? Is the
system CPU bound or disk bound? Can you move your temp space to
a RAM disk? That could help if your doing a lot of sorting.

Can you identify poorly performing queries and add (or drop)
indexes? Have you got performance measurements - reads/writes
marks/fetches? Plans? Problems on the database side can often
be fixed without changing the application, once you understand
what they are.

You should probably turn off automatic sweep and schedule a
daily sweep during a slow time.

If you have UPS, you can probably switch off forced writes on
a Linux system.