Optimize queries: Do not retrieve known key used in the condition.

Review Request #121310 - Created Dec. 1, 2014 and submitted

Information
Milian Wolff
akonadi
1.13
1786371...
Reviewers
akonadi
dvratil, vkrause

There is no point in doing a select like:

SELECT foo, bar FROM table WHERE foo = needle;

That can be rewritten to say

SELECT bar FROM table WHERE foo = needle;

This reduces the data traffic with the mysql server.

it works!

Daniel Vrátil
Daniel Vrátil
Milian Wolff
Review request changed

Status: Closed (submitted)

Loading...