Cristiano,
As you are using W2k and are stuck with FB1.0.x:
FB 1.0.x struggles on multi cpu machines, and it is best to set the
CPU_AFFINITY to one cpu only.
Upgrade to FB1.5.x and you get much better mutli cpu ability, but more
importantly, classic server which scales better on multi cpu machines.
use "gfix -w async ...." to set the sweep interval to 0 so that sweep is
never run, but remember to backup and restore fairly often (once every 1-2
months). Further details of how to do this are in the operations guide.
Regards
Rich P...


-----Original Message-----
From: Cristiano Masi [mailto:c.masi@...]
Sent: 13 November 2003 13:21
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Speed up Firebird


Dear All,
since I'm very new on FB I've some questions for you:

I'm running my web application in PHP with Fb 1.0 SuperServer (not the
1.0.3) on a W2K machine with 2 CPU's.
The PHP application uses ibase_pconnect (persistant connection).
I have almost 1200 customers whose daily are connected to our servers.

Now i would like to "speed up" process givin more "power" to FB.

1- I would like to use 2 processors
2- I would like to gie more memory to FB
3- I would like to limit the pconnect to the DBserver (unless they don't
slow down the machine)
4- It seems that the sweep interval (set by default on 20000) slows down my
application every day

I know that FB 1.5 will help but I cannot use it in Production.

Thank you all so much,

/Cristiano.





To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/