performance optimizations

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 operates on a layer between any MySQL client application, for example, a PHP application and, the MySQL server.

On the TechnoSophos blog there's a recent post looking at how the swapping of a few technologies has made for a huge performance jump for a Drupal-based website.

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!

The Tech Report: "In the early days of GPUs, application-specification performance optimizations in graphics drivers were viewed by many as cheating.

Accusations were hurled with regularity, and in some cases, there was real cheating going on."

Phoronix: "Now that we have tested Mac OS X 10.6, we are seeing how its performance compares to that of Ubuntu Linux.

Ubuntu 9.10 "Karmic Koala" will be out in October and does have some performance improvements as our earlier tests have shown, but Canonical engineers have not been exclusively focusing on performance optimizations with this release.

Can the Karmic Koala outperform Snow Leopard? Yes and no."

In May we reported results of a Windows Server 2008 power test conducted by Michael Larabel at Phoronix.

Last week he released the results of his most recent open source versus Windows test, a test of Java virtual machine performance running in Ubuntu Linux, Windows Vista Premium, and Sun’s OpenJDK.