Page 1 of 1

PERFORMANCE ODBC SQL SERVER 6.5

Posted: Wed Oct 01, 2003 7:46 am
by ColinDow
I Have a report that takes ages to load into the designer(10plus) but once its loaded I can change the criteria and it brings back different result sets very quickly.____Once I distribute it and the user runs it (using OCX) the performance seems to drop to around the same speed as loading the report into the designer. This despite similar criteria being applied by the user.____Im not to bothered by the designer load issue but am keen to speed the runtime performance.____Are there any tips/tricks/ini settings/hints as to how to go about resolving this ?

=> RE: PERFORMANCE ODBC SQL SERVER 6.5

Posted: Fri Oct 03, 2003 11:59 am
by kfleming
[updated:LAST EDITED ON Oct-03-03 AT 12:00 PM (EST)]Try adding the line:__AlwaysRR=1__to the Database section of RSW.INI. It is likely that you will need to add this section name (in brackets which if I try to type here the forum software strips them out) since it is not there by default.____Kathleen__R&R Support