We are experiencing a problem with a client where they have SQL 7. When we did an update to their software, a few of the reports they print will take an unusual amount of time to run, as before the update, the reports ran quick. We use Access 2000 to create the reports, but then link the tables to SQL 7 for testing and we cannot reproduce the problem at our office. The reports run quick. Does anyone know what we might look at that is causing the problem. It's hard to determine when you can't reproduce the problem. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 7 Slow Performance
- Thread starter Neffro
- Start date
tlbroadbent
MIS
Check indexing on the Client Server. Are the tables properly indexed for the queries? Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
I'd also check the cursor types being used in your queries. I was surprised to find that in some cases ForwardOnly cursors (typical overall use for reports) can be far slower than Static curors. Step through it on the client system and see where the bottlenecks are, then check the cursor types.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
