Generating offline excel report
Posted: Sat Feb 06, 2010 1:56 am
Hi,
I'm running php site having sql server database. I've given facility to generate excel report having large data in that. Now I'm getting trouble while multiple user download report simultaneously as it slows down the site due to large queries.
so is there any way such that, if one use user requests for report, then it should run in background mode in sql server & may be creating temporary table, then after 10-15 min, php will get data directly from resultant table. so it would save time to wait for executing query & collecting result. This is just one of my idea, so is this possible or please let me know if you've any other ideas.
I'm not sure whether I should ask this question in this category or now. But any help is most appreciable.
Thanks in advance,
Vijay
I'm running php site having sql server database. I've given facility to generate excel report having large data in that. Now I'm getting trouble while multiple user download report simultaneously as it slows down the site due to large queries.
so is there any way such that, if one use user requests for report, then it should run in background mode in sql server & may be creating temporary table, then after 10-15 min, php will get data directly from resultant table. so it would save time to wait for executing query & collecting result. This is just one of my idea, so is this possible or please let me know if you've any other ideas.
I'm not sure whether I should ask this question in this category or now. But any help is most appreciable.
Thanks in advance,
Vijay