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 Po

Re: MySQL insert performance

2005-11-09 Thread Dhiren Bhatia
o 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 > > > > > > > > > Dhiren Bhatia wrote: > > > > -- >

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