Hi,

Alan McDonald wrote:

>
> [Alan McDonald] So you must also have to be very explicit with your commits
> and/or rollbacks? Instead of relying on page script completion enforcing a
> commit?

You should.
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.

Using explicit transactions prevents this.

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.

On high traffic servers, this would bomb the DB with connections,
slowing things down.

Somewhere in the PHP-documentation the use of persistent connections on
high-traffic-environments is discouraged, too.

/thomas