Hi Johan,
Thanks for that, it explains what's going on. I've added `date` to the
`coords` index and that seems to have sped things up considerably. Thanks.
- Jonathon
Johan Höök wrote:
Hi Jonathon,
MySQL is using the index for both queries,
as the column "key" in the explain result says.
Hi Jonathon,
MySQL is using the index for both queries,
as the column "key" in the explain result says.
Using index means that MySQL can find all info
it needs by looking at the index only, i.e doesn't
need to look into the table.
See:
http://dev.mysql.com/doc/refman/5.0/en/explain.html
for more
Hello,
I've been working on some queries with a large dataset (7.5 million
rows) and have been finding problems with indexes seemingly being
ignored for some queries - this obviously slows the query right down,
I've seen some queries take up to 30 seconds. This only seems to happen
when I us
