Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

low priority select

Status
Not open for further replies.

BB101

Programmer
May 23, 2001
337
GB
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).


--BB
 
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.




Want the best answers? Ask the best questions!

TANSTAAFL!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top