Re: Large import into MYISAM - performance problems

2008-06-05 Thread Simon Collins
won't work. If his blob field is plain text, then of course Load Data will work nicely. :) Mike -- Dr Simon Collins Data Grid Consultant National Grid Service University of Manchester Research Computing Services Kilburn Building Oxford Road Manchester M13 9PL Tel 0161 275 0604 -- MyS

Re: Large import into MYISAM - performance problems

2008-06-05 Thread Simon Collins
tting bigger. Regards Simon Ananda Kumar wrote: Simon, Why dont u split the file and use LOAD DATA INFILE command which would improve the performance while loading into an empty table with keys disabled. regards anandkl On 6/5/08, Simon Collins <[EMAIL PROTECTED]> wrote: I'm

Re: Large import into MYISAM - performance problems

2008-06-05 Thread Simon Collins
a considerable time, if at all. Can anyone suggest to me why this is happening and if there's a way to improve performance. If there's a more suitable list to discuss this, please let me know. Regards Simon -- Dr Simon Collins Data Grid Consultant National Grid Service Univer

Large import into MYISAM - performance problems

2008-06-04 Thread Simon Collins
able time, if at all. Can anyone suggest to me why this is happening and if there's a way to improve performance. If there's a more suitable list to discuss this, please let me know. Regards Simon -- Dr Simon Collins Data Grid Consultant National Grid Service University of Manchest