Subject Re: RE: [firebird-support] Speed up Firebird
Author Cristiano Masi
Thank you Rich!
Are you sure that once I'll use FB 1.5 I should use the classic on a W2K machine?
I've read that the superserver will be the leading point for FB 2



>
> 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/
>
>
>
> 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/
>
>