Thank you Sergey. Differences are clearly indicated by the results of SYS(3054,11).
When I LIST STATUS it appears to me that all of the tags and collation sequences are identical. Can you (or anyone) give me some guidance as to me what else I need to check? I am obviously missing something.
One more slowdown clue. The very first user in the morning does not, at first, see the speed degradation. However, as soom as a second user opens the .DBC's files the slowdown occurrs. Again, this behavior only appeared last week. For years previously we never experienced this issue.
Below are both the "fast" an "slow" results of SYS(3054,11):
* Slow ( Approx. 20 seconds):
Using index tag Ptname to rushmore optimize table patient
Rushmore optimization level for table patient: partial
Rushmore optimization level for table subscriber: none
Rushmore optimization level for table medcert: none
Rushmore optimization level for table typepick: none
Rushmore optimization level for table certkey: none
Rushmore optimization level for table meddetail: none
Rushmore optimization level for table procdetail: none
** The differences follow:
Joining table typepick and table medcert using temp index
Joining table certkey and intermediate result using temp index
Joining intermediate result and table meddetail using index tag Meddtlkey
Joining table subscriber and intermediate result using temp index
Joining table patient and intermediate result (Cartesian product)
Joining intermediate result and table procdetail (Cartesian product)
* Fast (< 1 second):
Using index tag Ptname to rushmore optimize table patient
Rushmore optimization level for table patient: partial
Rushmore optimization level for table subscriber: none
Rushmore optimization level for table medcert: none
Rushmore optimization level for table typepick: none
Rushmore optimization level for table certkey: none
Rushmore optimization level for table meddetail: none
Rushmore optimization level for table procdetail: none
** The differences follow:
Joining table patient and table meddetail (Cartesian product)
Joining intermediate result and table subscriber (Cartesian product)
Joining intermediate result and table medcert (Cartesian product)
Joining intermediate result and table procdetail (Cartesian product)
Joining intermediate result and table typepick (Cartesian product)
Joining intermediate result and table certkey (Cartesian product)
Thanks again!
Spencer
Previous
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