Posts from — October 2010

MySQL Paginated displays – How to kill performance vs How to improve performance!

Pagination is used very frequently in many websites, be it search results or most popular posts they are seen everywhere. But the way how it is typically implemented is naive and prone to performance degradation. In this article I attempt on explaining the performance implications of poorly designed pagination implementation. I have also analyzed how Google, Yahoo and Facebook handle pagination implementation. Then finally i present my suggestion which will greatly improve the performance related to pagination.

October 30, 2010   Views: 34,715   33 Comments

The effect of network latency on the performance of Apache pre-fork web server model

Web server performance is a complex topic, involving many variables. The most frequent of the variables that come to mind are database, CPU, memory and disk. The forgotten one is what we call “network latency”. In this post I attempt to describe how important a part network latency plays in the performance of a web server, most importantly when we are talking about web servers that follow the pre-fork model, such as the immensely popular Apache Web Server.

October 17, 2010   Views: 13,535   1 Comment