redfort

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

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.