RE - I have a situation where, within a PHP loop, I am creating over one hundred SQL statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated queries in one mysql_query() statement, and therefore only execute mysql_query() 5 times for 100 statements, as opposed to sending each statement individually? -------------------------------------- I know that it is possible to send multiple update / insert statements. However, it was my understanding that this is not normal SQL. I am using the Opta driver and it fails when I try to do this. I have successfully done it in MS-SQL. I would test this thoroughly and make sure that it's not going to fail if the DB driver of DB version is swapped out from under the code. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. GOD BLESS AMERICA! To God Be The Glory! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]