Re: MySQL insert performance

2005-11-11 Thread Dhiren Bhatia
Any ideas on how I can optimize this? Thanks. On 11/9/05, Dhiren Bhatia [EMAIL PROTECTED] wrote: This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app server database server running on the same box. I'm using the Tomcat Database Connection Pool to get a JDBC connection

MySQL insert performance

2005-11-09 Thread Dhiren Bhatia
How long should it take to insert approx 30,000 rows into MySQL. It takes me about 30 mins. I'm using version 4.1.10-nt. Any ideas? Thanks, Dhiren

Re: MySQL insert performance

2005-11-09 Thread Dhiren Bhatia
Dhiren Bhatia wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED