redfort Posted April 12, 2011 Share Posted April 12, 2011 Hi All, As we know........to export excel sheet the database content....we query the data base and then process the result and using Workbook and header we export the result in excel.................. Is there any way we can reduce the down load time or increase the performance for same. ? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/233452-performace-problem-in-export-excel-from-data-base-entries/ Share on other sites More sharing options...
betterphp Posted April 14, 2011 Share Posted April 14, 2011 you can increase the performance of your script by tidying up the code and removing necessary bits and by using built in functions where possible instead of your own code. Concentrating on the loops will get you the most gain. You could also have the script run every hour say and generate a static file, which would allow quicker downloads of the file at the cost of a bit of dynamic-ness. And for the download time, get a faster connection or make the file smaller. Quote Link to comment https://forums.phpfreaks.com/topic/233452-performace-problem-in-export-excel-from-data-base-entries/#findComment-1201795 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.