469,082 Members | 1,287 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

Optimizing imports

I need to have a web application be able to import large amounts of data
(400,000 rows of 10 columns). I know how to script it and have it running in
the background. However I want to know how I can optimize my insert
statements to try to speed things up.

Will it help if I insert multiple rows at a time? If so, is there a magic
number or range?

The same would also go for updates.

Thanks,
-Jackson

--
jackson miller

cold feet creative
615.321.3300 / 800.595.4401
ja*****@coldfeetcreative.com
cold feet presents Emma
the world's easiest email marketing
Learn more @ http://www.myemma.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 1075

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Flashman | last post: by
1 post views Thread by Steven K | last post: by
1 post views Thread by The Confessor | last post: by
1 post views Thread by Arpan | last post: by
1 post views Thread by Thomas Wittek | last post: by
5 posts views Thread by kimiraikkonen | last post: by
reply views Thread by Kay Schluehr | last post: by
3 posts views Thread by Mohamed Yousef | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.