RE: [PHP-DB] One big query vs. lots of small queries

2006-12-18 Thread Bastien Koert
stien From: Jeffrey <[EMAIL PROTECTED]> To: PHP DB Subject: [PHP-DB] One big query vs. lots of small queries Date: Mon, 18 Dec 2006 15:23:36 +0100 Here's a question of efficiency. I have an application in PHP using MySQL. Users select items on a form and each selected item represents

[PHP-DB] One big query vs. lots of small queries

2006-12-18 Thread Jeffrey
Here's a question of efficiency. I have an application in PHP using MySQL. Users select items on a form and each selected item represents a change in a table row. It is possible that 100s of changes might be chosen from a single form. Which is likely to be faster/more efficient? multiple qu