"Ross J. Reedstrom" wrote:
> Mike Mascari gave you a detailed answer to that, which you seemd to just blow
> off, based on you guesstimate that it would run too long:
That is a separate issue - unrelated to this performance issue and it
was not "blown" off, I was merely making a comment.
> Right, as your explain output showed: the planner is picking this index
> and using it. I'd guess that your time is getting lost in the sort step.
I think you're probably right. It's hard to imagine that sorting is that
much slower, but it's hard to say.
Your ideas for selecting based on the date are intriguing, however the
schema of the db was not done with that in mind. Everyone thinks I'm a
nut when I say this, but the date is stored in a char(14) field in
gregorian format: 19990101125959
So perhaps sorting a char(14) field is somehow majorly slower now.
No I don't have 6.5.3 installed anymore - it was totally fubar and
wasn't running anymore.
Tim
--
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723
