About -> News -> Prepared Statements, a 25% boost
OpenSIPS 1.5.0 gets MYSQL prepared statements
Starting with OpenSIPS 1.5.0 the internal DB API provides support for prepared statements. First DB module to implement prepared statements is DB_MYSQL module. See more about the concept of prepared statements in MySQL.
A set of tests were conducted in order to determine the real gain of prepared statements. The tests tried to cover various case - combinations between complexity of a query and the amount of data transfered by a query.
A very good overview on Prepared Statements, that may help you in understating the advantages and disadvantages of prepared statements can be found at http://www.mysqlperformanceblog.com/2006/08/02/mysql-prepared-statements/ .
Following the measurement with the new prepared statements a 25 % increase in performance. See the entire set of test as well as the result interpretation.