We have BO Publication with Source reports as WebI and Dynamic recipient as WebI report which has around 8000 rows.
The reason of having Dynamic recipient Webi report is we have section on Store ID in main report which should generate separate mhtml file for each section so that is why we wnet with Publication.
But we are facing performance issue with Publication which is running for around 3hrs.
In our BO 4.2 SP6 Server multiple Publication are running concurrently and we are facing slowness.
We have Distributed the APS server as SAP suggested still we cannot see improvemnt. Normal reports are running within 6 minutes.
Need expert advise on how we can increase the performance