Re: [firebird-support] FW: Scale-ability problems (PHP + firebird)

2015-11-04 Thread map...@gmail.com [firebird-support]
ibase_pconnect uses the same function as ibase_connect internally (the only diferrence is that is reusing connections) So I recommend to start with it http://php.net/manual/en/function.ibase-pconnect.php http://php.net/manual/en/function.ibase-pconnect.php

[firebird-support] FW: Scale-ability problems (PHP + firebird)

2015-11-04 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Hi Rudi, we have a PHP & Firebird environment too. To Reduce the overhead problems we use some caching techniques. So the amount of connections for a new site request shrinks dramatically. On the other side we're trying to reduce the amount by rewriting / optimizing some core queries. The

[firebird-support] FW: Scale-ability problems (PHP + firebird)

2015-11-03 Thread Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
We host a php + firebird app for several years now, but as of late we are running into some scalability issues mainly with firebird. One of our new clients have about 120 users each which makes intensive use of the system and many requests to the database. The queries/indexes are all