On Nov 26, 2007 1:36 PM, Bill Moran <wmoran@potentialtech.com> wrote:

I have one additional question. You say the following:
"MySQL's query cache makes its performance better. This can be demonstrated by restarting MySQL, then visiting the home page of the site and seeing the query time in devel's output. However this is not as marked as what PostgreSQL takes."

Could you explain/clarify that statement?

What I meant is that even when the query cache does not kick in, MySQL is still faster than PostgreSQL.

An easy way to do that without fiddling with MySQL variables and such is to restart mysql, then hit the front page, see what devel says, then hit it again and see the difference. That difference is due to the query cache.

With query cache not yet caching any queries

 Page execution time was 92.74 ms. Executed 98 queries in 30.04 milliseconds.

With page's queries cached in the query cache

  Page execution time was 63.61 ms. Executed 98 queries in 10.38 milliseconds.

Still, 93 ms is faster than PostgreSQL's 130 ms.
--
Khalid M. Baheyeldin
2bits.com
http://2bits.com
Drupal optimization, development, customization and consulting.