load big file into database by php
Posted: Sun Mar 04, 2007 1:09 am
hi
i am doing an app that needs maintenance every month
this maintenance is the creation of a table for the month and the upload of a file with nearly 20 million rows to populate the table
this should be done by a web interface
the problem here is the time it will take to complete this process, there may be a php max execution time error
i was thinking about using async call to leave this process running
maybe someone can help with any solution
PD: i am working with mysql 5.0.27
thanks
i am doing an app that needs maintenance every month
this maintenance is the creation of a table for the month and the upload of a file with nearly 20 million rows to populate the table
this should be done by a web interface
the problem here is the time it will take to complete this process, there may be a php max execution time error
i was thinking about using async call to leave this process running
maybe someone can help with any solution
PD: i am working with mysql 5.0.27
thanks