Re: Very slow performance??
Posted by: Mark Matthews
Date: November 01, 2004 11:40AM


The difference between the two methods is 1999 network round trips, and 1999 times more setup to execute and parse, both by the JDBC driver and the MySQL server when you execute 2000 statements instead of one. For tens of inserts you'd never notice the difference, but for thousands, these seemingly small costs add up.


Options: ReplyQuote

Written By
October 25, 2004 11:16AM
Re: Very slow performance??
November 01, 2004 11:40AM
November 02, 2004 10:32AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.