As you may recall, I recently discovered subqueries. While everything should seem functionally the same, you'll now be receiving subquery produced information when you view category pages. I think everything seems to be working OK thus far, although the subqueries seem to be a bit slower simply doing several queries, which suggests to me I must not be doing something right -- why would initiating multiple queries be faster than one complex query?
Hopefully, I'll continue working on adding functionality via subqueries in the near future.
Oh, and about commenting or the lack of the ability to do thereof: I think I finally fixed SAFARI so that commenting should be on by default on asisaid. I'll be distributing that minor bug fix to other SAFARI-powered sites, such as Ed's, once I stabilize the subquery work a bit more.
Trackback URL: http://asisaid.com/journal/trackback/965.html
If I remember correctly, you get tagged a certain time penalty each time you run a query. Meaning you have to make the connection, run the code and then close the connection. By doing subqueries, you only hit the DB once thus eliminating the multiple hits.
Your subqueries should not be that slow unless you have something funky going on there.
I’m mystified, because I assumed the same thing you did. Maybe I did do something odd, I might try again. At any rate, doing the exact same query with a JOIN instead is much faster and still keeps it down to one query.
Please enter your comment entry below. Press 'Preview' to see how it will look.