Re: speeding up UPDATE and INSERT

Hi, I also do a similar thing with my data pre-processing scripts. I use a multiple insert command with INSERT DELAYED. It has improved the performance by heaps. The format is INSERT DELAYED INTO table VALUES (c11, c12, c13), (c21, c22, c23); The INSERT DELAYED will delay the updates so

Error 111 message

am using apache as my web server. Rasika Amarasiri - 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