PERFORMANCE ODBC SQL SERVER 6.5
Posted: Wed Oct 01, 2003 7:46 am
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 ?