Currently browsing

December 18, 2012

Scenario based Index type selection

Scenario based Index type selection Introduction When we are thinking about index we have different options in mid to use them, such as Clustered / Non Clustered etc. It is very important to understand in which scenario what type of Index gives us the performance boost up. As we all …

MySQL or MySQLi or PDO

MySQL or MySQLi or PDO pre { background-color:#444; white-space:pre-wrap; font-size:84%; padding:0px 6px; } Lessons learned: MySQLi is 50 percent faster than MySQL when fetching more than 1000 datasets MySQLi is 100 percent slower than MySQL when fetching less than 1000 datasets PDO is 15-300 percent slower than MySQLi (value increases …