Report Painter Performance Issue

[Former Member]

Helloo experts,

I have a report painter report which is pulling the data from a custom table (which has 32million records). Its taking a lot of time .

Is there any method to improve its performance ?

[former_member194669]

Hi,

Please check report painter selecting records using primary key or secondary index. If not please create secondary index for custom table (after consultation with basis, due to creating the secondary index will increase the load on server of custom table with 32 millions records)

If not possible. extract the resultset from custom table into another table and make query for report painter on that. and update the new table on daily basis or hourly basis.

aRs

[Former Member]

Hi as,

Thanks for your reply. But, the problem is i have many reports based which are pulling the data from the same table. So indexing will not help in this case.

Is there any other way like using summarization levels etc....???