Mysql optimization: Difference between revisions
From wikinotes
m (Will moved page Sql: optimization to Sql optimization without leaving a redirect) |
No edit summary |
||
Line 1: | Line 1: | ||
= Explain = | |||
<blockquote> | |||
</blockquote><!-- Explain --> | |||
= Timing Queries = | = Timing Queries = | ||
Revision as of 20:35, 9 August 2022
Explain
Timing Queries
Test adding Index
Rather than a JOIN
or IN/NOT IN
,
substitute values for the primary-key values and time it.
Limit Records
The more records included, the slower the query. If you can limit by a date-range that helps a lot.