New HTTPD!

I just checked in a new httpd that speeds up browsing. It does this simply by not doing 2 joins that are unnecessary when just getting the list of categories and their counts for the browse hierarchy. In tests on dublin, the query went from 1.12 seconds to 0.21 seconds (81% faster). Note that this only affects the “simple” browsing case; not when browsing My Cookbook, another user’s recipes, search results, etc. Test it today so I can push it to the live site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s