I have an SQL query which takes around 2 seconds to run, it's part of an admin tool, and as such is not mission critical. Is there a way I can make these selects have a lower priority than the normal ones (i.e, the ones on the site).
I haven't been able to find any information in the MySQL online manual for making one SELECT query have a different priority than another.
The only thing I have found is that SELECT queries have lower priority than UPDATE queries unless you specify the "HIGH_PRIORITY" option in the SELECT query.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.