I have a table right now that has slightly over half a million rows, and
will soon have about 1.2 million rows. The rows consist of and id
number (not unique) followed by data that cooresponds to that id
number. If I query based on an id number it is possible for 100 to
potentially 50,000 rows to pop up. The problem is that it takes a good
amount of time for the query to execute when it returns a large amount
of rows. It seems to be fairly quick when the result is small. Is
there anyways that I can speed this up for the large results? I am
using just the standard SELECT * FROM TABLENAME WHERE ID=VARIABLENAME.
Any suggestions would be highly appreciated. Thanks
Kevin
Received on Wed Sep 16 1998 - 06:59:33 CDT
