I have a Delphi 7 server application with Advantage Server version 10 as the
backend. Our little web site has grown to over 800,000 unique visits every
month and continues to grow. We experience a slow down (server utilization
jumps to 90% and stays there) between 11:00 and 1:00pm. It's hosted at
Rackspace and have lots of band width, so I cannot point a finger at them.

Short of upgrading our server (in the works) what other things can I do
with Advanage Database Server to speed things up? I've already have a
ads.ini, thanks Chris that helped for while. I contineu to tune my SQL
statements.

TIA.

Jay Wright.