With the correct indexes this query should run in less than a second.
Basically what you should do is make an index for every column that is used
in the where clause. For instance, if you had a query ... WHERE A=X AND B=Y
AND C=Z (A,B,and C are in the same table) you would create an index (A,B,C)
Folks,
I am with Security Managment Consulting, and we have a liscensed copy of
mysql. I don't have the lisc. # on hand.
We have a very large database in mysql, and one of the tables (call it
badge_history) has about 4,000,000 records, with the potiental to get
much bigger...
Now, we are using
