- Jay Pipes, Tobias Asplund
- Finding out the number of rows that would have been returned
(MyISAM and InnoDB)
- SQL_CALC_FOUND_ROWS and FOUND_ROWS()
- COUNT(*)
- MEMORY table
- if query cache is on, then it makes no difference
- if it's off
- Memory MyISAM is fastest
- FOUND_ROWS() is slightly slower than count(*)
- more in the slides that I'll add later
- quite a lot of humor, these guys are fun
-
query union vs index_merge union
- SELECT … WHERE a UNION SELECT … WHERE b
vs
SELECT … WHERE a AND b - index_merge wins
- SELECT … WHERE a UNION SELECT … WHERE b
-
composite index vs index merge
- …
Showing entries 1 to 1
Apr
16
2008
Showing entries 1 to 1