Import .csv to mysql

Avatar
raphaelviera
  • Answered
Hello, I'm importing .csv files to Open Classifieds. When i import 4.000 ads it takes like 20 minutes to process or sometimes stop in the middle. Is there anything that I can change in the .htaccess configuration to improve the import performance? I already have this in my .htaccess: php_value post_max_size 200M php_value upload_max_filesize 200M php_value max_execution_time 259200 php_value max_input_time 259200 php_value session.gc_maxlifetime 3600
Replies 1
Avatar
0
anonymous
Hello Raphaelviera,

Unfortunately there is nothing you can add to your .htaccess file to make the server process your MySQL import quicker. If you are on a VPS/Dedicated server with Root access then you can do some tweaks but if you are on a shared server then you would not be able to make those modifications.

Best Regards,
TJ Edens