topic Report Painter Performance Issue in Application Development and Automation Discussions

Report Painter Performance Issue

Former Member — Tue, 07 Aug 2007 23:30:43 GMT

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 ?

Re: Report Painter Performance Issue

former_member194669 — Tue, 07 Aug 2007 23:43:41 GMT

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

Re: Report Painter Performance Issue

Former Member — Wed, 08 Aug 2007 00:17:18 GMT

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....???