I added the suggested index and changed my sql and the subjective tests
seem to be improved somewhat. I checked EXPLAIN and it is using the new
index.
I still think there must be sorting going on, as the result is returned
instantly if you remove the ORDER BY. I don't know - I do think it's
much better now.
Thanks for all your help - I (of course) will let you know if I have any
troubles with corruption on 7.0.2 ;-)
Tim
--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723