Main.News0017 History

Hide minor edits - Show changes to markup

April 25, 2013, at 03:59 PM by razvancrainea -
Added line 1:

(:redirect About/News0017 quiet=1:)

February 05, 2009, at 11:31 PM by 92.81.68.225 -
Changed line 12 from:

Following the measurement with the new prepared statements a 25 % increase in performance. See the entire set of test as long as the result interpretation.

to:

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.

February 05, 2009, at 11:16 PM by 92.81.68.225 -
Changed lines 6-9 from:

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.

The 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.

to:

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.

February 05, 2009, at 11:10 PM by 92.81.68.225 -
Added lines 1-12:

Main -> 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.

The 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 long as the result interpretation.


Page last modified on April 25, 2013, at 03:59 PM