In article <[EMAIL PROTECTED]>, Stuart Felenstein <[EMAIL PROTECTED]> writes:
> How am I keeping transactions open ? Since I don't > want to do a transaction till the very end. All I'm > doing is bringing the data to last stage. After it's > all been collected. You don't "keep transactions open". You collect all the necessary data by PHP, and when you've got all of them (i.e. on the "last page") you do BEGIN; INSERT INTO table1 (data1); INSERT INTO table2 (data2); INSERT INTO table3 (data3); COMMIT; all in one go. Note that all tables must be InnoDB for that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
