Subject Re: [firebird-php] firebird, php adodb and session
Author Lester Caine
Didier Gasser-Morlay wrote:

> I am a php/firebird/adodb happy user. I now want to use the adodb
> sessions on firebird. what can you tell ? is it worthwhile ?

It just works for me. I've not done any comparisons, but since the
database is running on a second machine, it moves the load from web
server to data server. So I suppose it depends on where the bottlenecks
are happening as to if it is worthwhile. I just use a flag to switch it
on and off, so potentially I can use either way.

> how did you created the session table ? from the succinct doc I am not
> too sure how to convert it to firebird SQL lingo.

CREATE TABLE sessions (
sesskey CHAR(32) NOT NULL,
expiry INT NOT NULL,
expireref VARCHAR(64) DEFAULT '',
PRIMARY KEY (sesskey),

CREATE INDEX ix_expiry ON sessions (expiry);

> Any share of experience, especially with php5 if that makes any
> difference would be appreciated

I only use PHP5 so I can't comment on any differences to PHP4, except to
say that a lot of the Firebird PHP driver has been updated in PHP5, and
I don't think those changes have been back ported to PHP4.

> And while I am at it ... have a very good Chistmas for those concerned
> and a fantastic Year 2005 for all of us.

Here is hoping that Firebird gets a greater acceptance during 2005 ;)

Lester Caine
L.S.Caine Electronic Services