Does anyone have any ReportNet performance optimization tips?
Here's my specific problem. I have a report which I SWEAR was running quickly yesterday. Today, it's a dog. Anyway, the slow query section is designed like this:
Query Object
Parent Tabular Model (PTM)
Child Tabular Model (CTM)
where:
PTM
Data Items Filters
xxx PTM.xxx = CTM.xxx
yyy yyy = Jan 1
CTM.zzz
aaa
CTM
Data Items Filters
xxx yyy = Jan 1
yyy
zzz
The PTM and CTM sections both contain outer joins, and the resulting data is in a list, which is why they're in separate tabular models. Both tabular model queries run quickly individually, but when I run the whole query (at least for more than a small dataset), it gets really slow. As I said, I wasn't having a problem yesterday, but there doesn't seem to be anything exceptional happening on the database side.
Any thoughts?!
Thanks,
Stacy
Here's my specific problem. I have a report which I SWEAR was running quickly yesterday. Today, it's a dog. Anyway, the slow query section is designed like this:
Query Object
Parent Tabular Model (PTM)
Child Tabular Model (CTM)
where:
PTM
Data Items Filters
xxx PTM.xxx = CTM.xxx
yyy yyy = Jan 1
CTM.zzz
aaa
CTM
Data Items Filters
xxx yyy = Jan 1
yyy
zzz
The PTM and CTM sections both contain outer joins, and the resulting data is in a list, which is why they're in separate tabular models. Both tabular model queries run quickly individually, but when I run the whole query (at least for more than a small dataset), it gets really slow. As I said, I wasn't having a problem yesterday, but there doesn't seem to be anything exceptional happening on the database side.
Any thoughts?!
Thanks,
Stacy