Re: Is there a way to speed up Large database searches in SQL?

Dale E. Reed Jr. ( (no email) )
Mon, 04 May 1998 23:33:03 -0700

Rudy Komsic wrote:
> Maybe someone could help me on speeding up SQL Searches. We would like to
> offer a from - to period search on our database so our clients can view their
> time online. The one problem we are having due to our Huge database is that
> it can take several minutes for the results to appear. Is there any SQL
> Command that will stop searching after the specified date had passed?
> For example:
> Our database has information from December 97... and we would like to do a
> search from say January to February. But when we run the SQL Query it scans
> the WHOLE Database... Is there any way of telling SQL to stop searching after
> it Finds March?

The main thing to check is two things:

1. Make sure you have proper indexes on the fields you are checking in
the calls table (like the CallDate and Username fields)

2. Have ample memory allocated to your SQL Server so that it can cache
a good portion of the indexes and data pages.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |