On Fri, 2002-05-31 at 20:54, Cesar Mello - Axi wrote: > Hello, > > >You could maybe buffer the data in Your application > >and then run inserts later... like this. > > This is not a solution for me as the data acquisition can take hours without > any break.
Whatever you do, with any SQL you get stuck behind speed of parser. More commands means more waiting. Making one INSERT for two records instead of two INSERTs can speed up your stuff twice easily. This is general problem of SQL. Tõnu --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
