Subject RE: [firebird-php] RE: PHP Paging routine
Author Alan McDonald
> > to the files section of this yahoo group
>
> Thanks. Found it. Nice work on the update!
>
> Just out of curiousity, I'm implementing both EZ SQL & EZ Paging
> functionality and I noticed that although a new object for the database
> connection occurs for EZ SQL when its used, there seems to be no 'freeing'
> of the object (ie. Disconnecting from the database connection after its
> done). Does this imply that the connection to Firebird with PHP
> automatically disconnects at the end of the session?

it disconnects at the end of each page.

>
> I'm not sure how MySQL does this, but I've always been of the opinion that
> you need to explicitly disconnect from Firebird after a connection or you
> can create an enormous sweep problem for transactions. Is that
> not the case
> with PHP?

no - transactions are implicitly commited at the end of each page, so too
are connections disconnected - just do your regular backups everynight -
MySQL is the same - i.e. disconnect at the end of each page.

>
> Regards,
> Myles
>
> ===============================
> Myles Wakeham
> Director of Engineering
> Tech Solutions US, Inc.
> Phone (480) 451-7440
> www.techsol.org
>