Vanonet

Adding indexes to your tables is a great method to boost your application performance. Index helps database engine to quickly find requested data and performing efficient sorting and grouping operations. Today i was analized two similar bloghosting platforms. I was tried to find some bottlenecks in their architecture to enhance performance. First thing i was did is analize all important queries and add necesary indexes to related tables. There are great SQL statement which is greately helps in table optimization process^ EXPLAIN.

EXPLAIN SELECT * FROM SOME_TABLE WHERE ADATE<NOW()

This simple query gives you all required information to decide which indexes mysql will use to execute this query and you can easily decide to add all additional indexes.

For more information read mysql manual.

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.