Subject RE: [firebird-php] Re: ibase_trans
Author Alan McDonald
> Hi Alan,
>
> I'm using ibase_conect(bla, bla, bla). I heard someone to say tha
> pconection isn't good, but I'm not sure about that.

at one stage there was talk of pconnect not releasing the connections in the
pool. I'm not sure that's the case now.. but I always use connect anyway. I
proabaly don;t have enough traffic on my sites to warrant the use of
psonnect anyway.
Alan

>
> Would be necessary to commit (ibase_commit) in each page?

if you don't use explicit transactions, then explicit commits are not
necessary. If you need to rollback somewhere on the page for reasons of
design or catching an error, then you need explicit transactions which you
need to start and either commit or rollback.

>
> --- In firebird-php@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
>
> > no - every php page will start an implicit transaction when you open a
> > connection.
> > explicit transactions are only really required when you wnat finer grain
> > control. or if you want to rollback - since the implicit trans will
> always
> > commit unless there's a script error ont he page, in which case the
> trans
> > will rollback.
> > are you using connect or pconnect out of interest?
> > with this etup your transactions are always very short and suite. I
> would
> > not think that transactions are in any way connected to your
> experience of
> > slowness.
> > Alan
>
>
> []'s
>
> Thiago Ornellas
>