the report we using has lots of data, 4 reports in 1 report. we already splited the report as East and West but still my client asking me to increase the performance, Can anyone please help me in that, Any hints is Appriciated.
Hi VIajy,
I assume that you mean 4 queries in one report.
If the delay is:-
query execution then : specify query plans, refer to your database manuals,
data retrieval the : reduce the amount of data by improving queries,
: get a better dataline
report computation then : move processing back to server
: reduce report complexity
: improve variable computation efficiencies
: get a faster machine
What sort of improvement are you looking for, how many rows are returned? Perhaps there is no significant improvement possible,