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

[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)

[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 environment itself 
bases on the Zend Framework.

Hope this helps.

Regards
Martin

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

[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 performing very well, and we do heavy caching to
minimize database accesses.





We are inclined to think the problem is in the connection
creation/destruction overhead here.
We do not use persistent connections, and it may not be an ideal solution
for us, there are some reports that firebird persistent connections on the
PHP api are problematic.





I’ve been searching the web for the best practices and caveats I need to
know to implement connection pooling for firebird, but have been coming up
empty.


Can someone point me in the right direction here?





Our FB setup is 2.5, super classic.


The configuration is default besides these settings :





DefaultDbCachePages = 512


LockHashSlots = 60589


LockMemSize = 10097152


TempBlockSize = 8388608





Thanks,


Rudi