That seems like a long time. Although I don't know how much data you
are importing, how many indexes you have on the database, memory,
etc. How you are going about importing can affect your speed
dramatically. If you are importing a tab delimited (or other
delimination) file, you should get much better speed. If you are
importing a mysql dump that does individual inserts, then the speed
you are seeing may be the best you'll get.
On Nov 9, 2005, at 1:47 PM, Dhiren Bhatia wrote:
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
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]