Report Performance

sabzam

Dear All,

I have got a problem with a report. The performance is incredibly small. I have already applied a number of filters but unfortunately it would still need to call seeral times to the table in the db itself. Do you suggest to copy all the table in a temporary table rather than calling to it a number of itmes?

Steve.Desmedt

I think it's not a good idea to push all the records in a temp table.
Remember that you also have to access to tables to fill up your temp table.
Are you sure that U have used the right keys to access your tables ?

Grtzzz

kine

1) It depends on: count of records, structure of the relations etc.
2) Sometime there are more ways how to read the data from the tables. Best is if you have just one dataitem, worse is several nested dataitems. Sometime it is better to propagate some value from related table into the "entry" table and save one nested level in this way.