LibraryThing for Libraries gets MUCH faster
The Tag Browser in FAAAAST!
posted by Tim at 2:57 PM
Tuesday, May 15, 2007
The Tag Browser in FAAAAST!The Tag Browser in FAAAAST!The Tag Browser in FAAAAST!The Tag Browser in FAAAAST!
posted by Tim at 2:57 PM
3 Comments:
It's unclear exactly what you mean by "broken into two queries", but there are usually two things that go on here.
One is that the query planner ('explain') is simply wrong about some of the expectations, and the real results don't match well to the plan. I don't know MySQL, but with PostgreSQL you would try using 'explain analyze' on a few examples to see what's happening. In this case, once you smartened up the planner your original query would perform better.
The other is that sometimes it's just "better" to muck around with the data at the application level instead of the db level (especially once the datasets get small enough to handle), i.e., a coarser and much faster query is indeed sometimes the best choice, no matter how tempting it is to "perfect" it.
"If I were smarter, I'd understand this."
That pretty much sums up my entire life.
:-)
Post a Comment
<< Home