Add indexed to your calls table based upon your where clause. For
example, if you are doing a Where AcctStatusType=1, make sure the
AcctStatusType column has an index on it.
Don't go overboard on the calls table with indexes (it will slow
down inserts). I typically have about 8 indexes on our calls table
here and it fairly quick. The bottom line is adding more memory
to your SQL Server (and letting SQL Server access it) to get the
query times down. If you are sorting the results, use a tempdb
in ram of about 32 mb and it should really make a difference as
well (but don't run out of memory, or SQL Server won't start!).
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com