maria_tachi
Posts: 1
|
| Posted: 04/27/2010, 2:32 AM |
|
Hi
I would like to know is there any way that I can optimized the data before exporting the data to excel?
The situation now is that I have loaded 60K records loaded from the database and display using php and now I want to convert the whole results displayed to be exported to excel.
However, excel either takes more than half an hour to load or does or even load most of the time.
I have use set_time_limit(0) before but the time taken for it to load is more than half an hour to export the excel which means that it will be slower on my users' computer as their computer are not as powerful as mine.
Hence, I would like to know whether are there any other methods that I can used for exporting large data to excel? I have thought of checking out any function that can optimized the data before exporting to excel? Based on your experience, is there any function that can do that?
Thanks in advanced
|
 |
 |
datadoit
|
| Posted: 04/27/2010, 5:38 AM |
|
There are many factors at play here. To start, you may also want to
expand your PHP memory limit to handle the export. That's probably why
you're not getting an export at all on some occasions.
What happens if two folks run the export at the same time? You're
likely going to burp your web server for at least a few moments.
For such a large task, I highly recommend running this export as a
background process, then placing the output as a link to the file on
disk in a database table. That may sound daunting, but it's really
quite a simple concept once you understand the steps.
|
|
|
|
|
