redfort Posted December 20, 2011 Share Posted December 20, 2011 Hi , Presently we are preparing an excel for download report by querying to data base. We are querying to DB and looping through each result row and writing to excel. for 2lacs data its too much time. I found the time taken max in DB query and processing the DB data . Ant way I can make it faster ? Any parallel processing I can apply to get it faster......I expecting Huge data report in future. Quote Link to comment Share on other sites More sharing options...
trq Posted December 20, 2011 Share Posted December 20, 2011 You likely need to refactor your quires and your process. I'm working on a system at work that processes tens of thousands of records and creates pdf's. Allot more of an intensive process than creating excel files. Yet if things are done properly, it can be done. There are many little tricks but without any idea of your current process, we can't really help. Quote Link to comment Share on other sites More sharing options...
redfort Posted December 20, 2011 Author Share Posted December 20, 2011 Hi, My App is simple ..............I am querying to data base to get the feedbacks of people. with name and there feed back. there are around 2 lac of feed backs. when need to make excel for all the feedback I need to query the data base and process each feedback and put it in excel . tme consuming things are when i make query to fetch all the feedbacks and when process the query result....... let me know if u need any info Quote Link to comment Share on other sites More sharing options...
trq Posted December 20, 2011 Share Posted December 20, 2011 Code speaks volumes. Quote Link to comment 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.