Thomas Woinke wrote:

> Otherwise, you could run into situations, where you insert stuff
> somewhere at the beginning, and later in the script select it again, but
> getting "old" data, because you are still in the same transaction, using
> the snapshot from before your insert.

Are you sure about this?

It doesn't work that way. If you insert something, it exists inside your
transaction, so if you do a select, you WILL see those records. Try it
and see.

> And regarding persistent connections: don't!
> From my experience, I only can discourage from using those.
> PHP seems to be not very good at reusing existing connections, so it
> will open a lot of new ones, while not closing old ones.

I have seen this problem too. Using connect() is better.

--
Milan Babuskov
http://fbexport.sourceforge.net