Sometimes it's hard to get Views' queries optimized. I'm proposing a SQL Hints idea, where an admin could specify certain things- like forcing indexes. I'm mainly throwing this idea out there to see if it has any support. I'll expand on the idea soon.

Comments

moshe weitzman’s picture

moshe weitzman commented

views already has a 'prequery' hook where you can massage the SQL. Or you can intercept earlier and modify the query object. this might not be needed.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (fixed)