On Mon, Mar 24, 2003 at 04:24:52PM +0100, Beck, Mike wrote:
but if i set autocommit to false in the mysql
serversettings and in the
php.ini set php to use persistent connections as default do you think it
would work?
if that chance exists i'd start thinking if there is any useful way to help
using transactions on innodb tables in pma, but i think that even if you use
persistent connections these are only persistent within one apache child, so
chances are that the connection is lost nevertheless and thus transaction
can never work.
There is no gaurentee that you'll get the same persistant
connection
unfortunetly. If your browser really used HTTP/1.1 keepalive, you'd
stand a better chance of it, but really that is no way to do it.
I do already use transactions on InnoDB tables myself.
can anybody tell me more there?
The only
workaround that is possible if we want transaction support in
PMA would be to buffer the queries inside PMA, using our own seperate
table, and then sending them atomically to MySQL on COMMIT or just
dumping them on ROLLBACK.
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page :
http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639
GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85