Hi,
I was read from this group about LOAD DATA query performance. Someone was
tell me that when load large data text file into database which has primary
key or index may be slow. The way to make load data faster is drop and
create table without index, after load data then create index again. But I
found the opposite respond, I have text file (with delimited) about 5 mb
(for table 126 fields, 1 PK, 2 indexes, 7500 rows). this is the respond time.
- load data with drop->create table->add PK, indexes take 50 second
- load data with empty tale (still have PK & indexes) take 26 second
What's wrong with my environment or load data concept?
Sommai
----------------------------------------------------------
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
----------------------------------------------------------
---------------------------------------------------------------------
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
