Its probably because it has to do a full table scan, since you don't
an index that suits your criteria. You could try specifying one, or
use SQL Query Analyer to recommend one.
I would guess you are running into a problem with RadiusNT inserting
records into the table, while you are trying to read them. I'd have
to see your table/index list to really make a guess at the problem,
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart