CodeIgniter Forums

Full Version: Suggestions on Importing data from XLS (Excel) of 100,000 records
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]Manjunath Reddy[/eluser]
Hi Folks,
I have a XLS file with 100,000 records. Basically I have to extract data from XLS and distributed to few tables in my database. Before I did this with about 9k records, works well but performance issue, It would take about 9-15 mins depending on my network traffic, to mention its locally. If I were to run in my production i'm not sure how long it would take it.
I'm not ready to make php script to run from command prompt I guess that would be bit faster than running it from browser, as customer do not want to do that way.

My Idea was to run from the browser with by
- Uploading the XLS file to Server
- Parsing the XLS file
- Extracting each column and store in the tables
Considering 100k records, I guess it would take an half hour or an hour for migration.
any other suggestions would really appreciate.

El Forum

[eluser]Manjunath Reddy[/eluser]
Hi BG,
Agree with you, yes I follow the same approach, working fine, but I still need to tune the performance. will update later on this issue.
Thank you very much for your time. appreciate that.