Assuming both scenarios only had one connection open for all the statements, you probably will see a savings. You will need to benchmark your situation.
You will need MySQL 4.1 or greater and your ODBC driver will need to support this version as well. Ed -----Original Message----- From: Paul McNeil [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 1:24 PM To: MySQL General Subject: Multiple Queries 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]
