hkflight (1/25/2012)
Thank you both very much for your help. Unfortunately, I cannot control indexes or queries as they are part of the software and if I changed them, future updates to the software would break things.
Your situation is familiar to me. Would your system be either a Touchstar Systems or Noble Systems product?
If so, I can give you specific information on the cause of your system's slowdown and instructions on how to dramatically improve its performance to better than acceptable levels.
If not, then I have a question: How fast is your database growing and is the growth isolated to just a few tables?
LC