Report.Regdata is taking too long.

[pmoita]

I have been doing some tests with a very simple report (2 to be more exact, first one with customer's name. address, phone, etc. in each page and the other lists customer's name and phone).

Both samples worked well while using sample data (less than 20 records on DB). Problem came when I tried to use our test DB (About 65000 records).

After some tests I came to the conclusion that it is RegData that takes very long time to finish.

I placed a timer just before and after the Report.Regdata call, and set StiOptions.Dictionary.BusinessObjects.MaxLevel to 2,3 or 4, but didn't notice any changes. These are some of the results:
Query returns 22 records takes average of 5 seconds, 123 records takes average of 45 seconds and 1168 records takes 5 minutes.

What is regdata doing to take so long ?

[HighAley]

Hello.

It's very hard to give you an answer while we don't see your code.
Could you send us a sample project which reproduces the issue?

Thank you.