Subject | RE: [firebird-support] Compiling SS for OS X |
---|---|
Author | Nigel Weeks |
Post date | 2004-05-18T06:08:12Z |
> It looks like the there is only Classic for OS X. Is there anyPHP can't connection pool properly, with SS or CS - but if you're using
> problem/reason that SS should not be run on OS X? What would I need
> to download in order to attempt it? I would like to keep it so that
> my install follows the layout of the Classic binary (I don't know if
> the locations of the directories will be automatically by the
> compilation process).
>
> My reason for wanting to use SS is that I will be creating a web app
> using Jaybird or PHP for connection pooling, and I want to ensure that
> there is a single cache to maximize the potential for a client making
> consecutive connections.
>
> Regards Bernard
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.