SemanticScuttle performance optimizations - Christian Weiske

Courtesy Planet PHP  Sat, 02/20/2010 - 06:03

This week I worked on lowering the number of queries that SemanticScuttle needs to deliver a bookmark listing page.

Just looking at the front page of a SemanticScuttle instance with 10 or more bookmarks, not logged in, caused 37 SQL queries to be fired to the database.

If you are logged in, doing the same action took SQL 54 queries!

After my optimizations, it only takes 8 queries for the front page for anonymous people...

Tags:

 

More related items

NetTuts.com: Turbocharge your Website with Memcached
On the NetTuts.com site there's a new tutorial showing you how to introduce the Memcached tool to your application - a quick and easy way to cache data and optimize performance. Your...

MySQL Transaction Gotchas & Good Parts - SitePoint »...
In my previous post, “MySQL Transactions & Why You Can’t Emulate Them in PHP” we discussed why transactions are useful and how a few simple SQL commands can make your application more...

mysqlnd plugins: alternative to MySQL Proxy ?! - Ulf...
The mysqlnd plugin API is a well hidden gem of mysqlnd. Mysqlnd plugins operate on a layer between PHP applications and the MySQL server. This is comparable to MySQL Proxy. MySQL Proxy...


 

Post new comment

The content of this field is kept private and will not be shown publicly.
computer-internet.marc8.com