11/25/2024 9:38:58 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
First Run Per report fast - subsequent runs slow down badly!!
Posted: 15 Mar 07 12:29 PM
|
fiogf49gjkf0d Hi Everyone
SLX v7.01 - OS windows server 2003 SP2 (also replicated on win XP)
DB size = 400000 accounts 3 million history records
When a user runs a report on the current group, the report is fast (happily).
If they click onto another report and run it for the current group that too is fast
I can repeat the step above and each time all is good, until I choose a report that has already been run, this time the report is painfully slow (over 5 minutes compared to a few seconds).
Does anyone recognise this and have any ideas what could cause the second run of a report to go so much slower.
The same happens if I run report a, click on report b, then click back on report a, and generate the report.
Any ideas?
Nick |
|
|
| |
|
Re: First Run Per report fast - subsequent runs slow down badly!!
Posted: 26 Mar 07 9:03 AM
|
fiogf49gjkf0d Cheers RJL,
It is happening with both OOTB reports and custom reports. The only filters being added are the ones added by the SLX field 'Show records that match:' in the reports view. Note the same behaviour is exhibited when using just current record.
Nick |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|