How perform data base reporting

[redfort]

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.

 

 

 

 

[trq]

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.

[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

[trq]

Code speaks volumes.