Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?

[Ronald Brown]

Rick James Wrote:
-------------------------------------------------------
> If you are able to outsmart the optimizer, then
> you should go work for Oracle or MariaDB and fix
> the code.


what i meant is,

there are queries which are taking wrong index , so as you suggested above to use Ignore index .

i just wanted same to implement in my php code,

e.g.

lets say if query x is slow taking 6.xx seconds , then depending on the paramaters or where clause its going to use , use ignore specific index. as ignoring index makes query run in 0.1x seconds.

is this viable solution ?

how are big sites doing it? 6.5 mil rows are not much as compared to the other big sites out there with millions of rows .

just my thaughts.

thanks