Hi! I need to import large CSV files (30 000 lines) It takes very long time (and web error 504) is it possible to import using begintransaction() and commit ?? OR using function do_import($data) to write my own import routine, but How to read CSV file line by line ? Thaks for your help Regardd Georges
Hello,
I reviewed the code and it seems like it’s due to the limitation of php memory limit.
The current implementation is to store the uploaded file in the php array then to session at step2. And on step3, reads the array from session and insert in database.
So most likely, it’s a php memory limit case. You can confirm it by checking php error log.
The current implementation can also be optimized. let me know if increasing memory limit does not solve your case.
Hi Abu
I wrote a specific PHP code to solve my problem, using begintransaction() commit()
but it’s not a long term solution because CSV file structure can change
I don’t know how to change php memory limit. Can you explain?
Regards