[Kde-pim] Review Request 121310: Optimize queries: Do not retrieve known key used in the condition.

Milian Wolff mail at milianw.de
Tue Dec 2 18:26:38 GMT 2014


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://git.reviewboard.kde.org/r/121310/
-----------------------------------------------------------

(Updated Dec. 2, 2014, 6:26 p.m.)


Status
------

This change has been marked as submitted.


Review request for Akonadi, Daniel Vrátil and Volker Krause.


Repository: akonadi


Description
-------

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.


Diffs
-----

  server/src/storage/entities.xsl 94712933564a8f6c1bf99502e4af837f5934d41e 

Diff: https://git.reviewboard.kde.org/r/121310/diff/


Testing
-------

it works!


Thanks,

Milian Wolff

_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/


More information about the kde-pim mailing list