September 2013

What is indexes in mysql?   A database index is a data structure that improves the speed of operations in a table. A mechanism to locate and access data within a database.   More about index: 1) Speed up data retrieval 2) Speed of selects …

You can enable/set up cache validator from .htaccess.  Insert below code in your .htaccess file and restart Apache server.   ========================================= <IfModule mod_expires.c> ExpiresActive on # Perhaps better to whitelist expires rules? Perhaps. ExpiresDefault                          “access plus 1 year” # cache.appcache needs re-requests in FF 3.6 …

Apache Performance tuning :   1) Hardware and Operating System Issues:   The single biggest hardware issue affecting web server performance is RAM. A web server should never ever have to swap, as swapping increases the latency of each request beyond a point that users …