General information
Title:
Big speed issues when making the jump to 9.0
Environment versions
Network:
Windows 2003 Server
We recently did a test run for converting our 8 sp1 application to 9 and have run into some issues. When certain queries are ran the execution time goes from 15-20 seconds to 10 minutes! After walking through some of the code I have noticed that part of the query is not working properly, in 9 only! The exact same query works just fine in 8. They are being ran off of the same data as well. The coding is for a quasi multidetail line report but it is not limited to this select statment. Basically the test code took the contents from two cursors and inserted them into one cursor for reporting. The probelm occurs when the second curusor is loaded, it loads all the recrods instead of the single record needed. Is there a program setting that I am missing here (tried the report behavior one - no luck) or something?
Just starting to do some digging
Thanks in advance
Kelly
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only