Welcome Guest, Not a member yet? Register   Sign In
Suggestions on Importing data from XLS (Excel) of 100,000 records
#1

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

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





Theme © iAndrew 2016 - Forum software by © MyBB