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.


Messages In This Thread
Suggestions on Importing data from XLS (Excel) of 100,000 records - by El Forum - 01-15-2012, 10:54 PM



Theme © iAndrew 2016 - Forum software by © MyBB