yes, that is fixable (if you really have hit a mysql wall)
you can do a coupla things.. run mysqltuner.pl (freely available on the web) and follow its recommendations as to tuning your my.cnf
or i've suggested this to Rick and it definitely increases the query speed and decreases the load 10 times at least!
that would be to add another index to the ubbt_POSTS table equal too a large number MINUS the Post posted time... this would make the query NOT have to do that awful reverse (DESC) sort after the WHERE is satisfied, since the new index would be naturally reverse in nature
in most cases, it is the sort that causes the massive headache in very large installs..
I've given Rick the info on this, and i even think he said 'good idea bla bla..' but it isn't in stock yet..
I have 2 extremely large sites where it has been running for years and can be confident it will help..
note: it would be a modification to stock tho..
<insert all that stuff giz types about voiding warranty etc etc>
