I have a customer that needs to load daily files that will range anywhere from 3000 to 10000 records. Needless to say the web import tool is crazy slow doing this. What is the best practice for this sort of file load? php,ini modifications, mysql tuning, external software to import directly to mysql like starfish?
Thanks in advance for the guidance!!