If cardinality is high (i.e large number of rows returned in the set for
your query), then mysql may need to resort to filesort.
- Ashish
2010/6/21 Octavian Rasnita octavian.rasn...@ssifbroker.ro
Hi,
I have made an InnoDB table and I am trying to search using some keys, but
they are not
Hi,
I have made an InnoDB table and I am trying to search using some keys, but they
are not used, and the query takes a very long time.
Here is a test table:
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`symbol` varchar(20) NOT NULL,
`market` varchar(20) NOT NULL,
Hi Octavian, all!
Octavian Rasnita wrote:
Hi,
I have made an InnoDB table and I am trying to search using some keys, but
they are not used, and the query takes a very long time.
Here is a test table:
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`symbol`