> PHP can't connection pool properly, with SS or CS - but if you're using
> Apache and Firebird CS, just use persistent connections.
> PConnect and CS provide a dataset cache for each connection running - not
> quite as good as a single cache(ala SS), but better that no cache, and it
> scales far better than SS can anyway.
> (SQLRelay can connection pool in between PHP and Firebird, but the
> difference didn't really make it worth the hassle)
>
> It takes 7 lines of PHP to do a query over a persistent connection:
> <?php
> $conn =
> ibase_pconnect("server:/path/to/database.fdb","sysdba","masterkey");
> $sql = "select 'Hi There!' as greeting from rdb\$database";
> $rec = ibase_query($sql);
> $obj = ibase_fetch_object($rec);
> echo "Greeting from database is:".$obj->GREETING;
> ?>
>
> Easy, and the connection is still open for the next connection.
> CS and pconnects produce extremely fast webapps - be prepared!
>
> N.

Just remember to keep your eyes on the server memory use. pconnect is
notorious for obtaining a new connection and not utilising existing ones
recently let go. You get a build up of unused connections in the pool.
Alan