vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Mark Kirkwood > > The 'desc' seems to be the guy triggering the sort, e.g: > > Oh; really an accident that I didn't notice myself, I was actually going > to > remove all instances of "desc" in my simplification, but seems like I > forgot. If desc is the problem you can push the query into a subquery without sorting and sort the result. This is called an inline view. Sometimes you can pull a couple of tricks to force the view to materialize before it is sorted. aka select q.* from ( some_complex_query ) q order by ...; Merlin ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |