Do not use ORDER BY id in search queries

sipcapture / homer-api

HOMER 5: Back-End (API) DEPRICATED - use sipcapture/homer-app

http://sipcapture.org

27 stars 67 forks source link

Do not use ORDER BY id in search queries #73

Closed rbott closed 8 years ago

rbott commented 8 years ago

As described in Issue 58, we have provided a patch to make the ORDER BY in search queries optional. Sorting by ID confuses the mysql optimizer and provokes a filesort in some mysql versions.

adubovikov commented 8 years ago

Can you please sign cla.qxip.net?

rbott commented 8 years ago

done.

adubovikov commented 8 years ago

thank you!