Report painter performance problem...

[Former Member]

I have a client which runs a report group consists of 14 reports... When we run this program... It takes about 20 minutes to get results... I was assigned to optimize this report...

This is what I've done so far

(this is a SAP generated program)...

1. I've checked the tables that the program are using... (a customized table with more than 20,000 entries and many others)

2. I've created secondary indexes to the main customized table with (20,000) entries - It improves the performance a bit(results about 18 minutes)...

3. I divided the report group by 4... 3 reports each report group... It greatly improves the performance... (but this is not what the client wants)...

4. I've read an article about report group performance that it is a bug.

(sap support recognized the fact that we are dealing with a bug in the sap standard functionality)

http://it.toolbox.com/blogs/sap-on-db2/sap-report-painter-performance-problem-26000

Anyone have the same problem as mine?

Edited by: christopher mancuyas on Sep 8, 2008 9:32 AM

Edited by: christopher mancuyas on Sep 9, 2008 5:39 AM

[Former Member]

Report painter/Writer always creates a prerformance issue.i never preffred them since i have a option with Zreport

now you can do only one thing put more checks on selection-screen for filtering the data.i think thats the only way.

Amit.