Hello All,
I have a strange situation while doing Bulk upload (using LOAD DATA
FILE). I have a database which has 600000 records, when I try to insert
10000 more records it is taking around 50-55 seconds to complete the task
(I feel this is much higher than the normal timings). I notice a strange
thing that time taken to upload 10000 records reduces to 10 to 12 sec
after I run a big query (a query that needs full table scan) on that table.
Can someone explain why this happens... I run MySQL 4.1.5 Gamma, on
windows 2003 Server OS.
Regards,
Ramesh
Confidentiality Notice: This transmittal is a confidential communication. If
you are not the intended recipient, you are hereby notified that you have
received this transmittal in error and that any review, dissemination,
distribution or copying of this transmittal is strictly prohibited. If you have
received this communication in error, please notify this office immediately by
reply and immediately delete this message and all of its attachments, if any.
