CodeIgniter Forums
Suggestions on Importing data from XLS (Excel) of 100,000 records - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forum-22.html)
+--- Thread: Suggestions on Importing data from XLS (Excel) of 100,000 records (/thread-48417.html)



Suggestions on Importing data from XLS (Excel) of 100,000 records - El Forum - 01-15-2012

[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.



Suggestions on Importing data from XLS (Excel) of 100,000 records - El Forum - 01-19-2012

[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.