>I have a table include 100,000 records.I use SELECT command to do query. The result is very slowly. It's about 1 miniute. Do you have any idea to slove this problem ? Why does the SELECT command so slowly , if
>the table is large.
If you have the tags well setted up, the query should be instantly unless the query returns an extremely large number of records.
Can you show us the SELECT syntax you have and we will tell you how to optimize it?