[Devel] [ openser-Patches-1717848 ] MySQL Prepared Statements

[SourceForge.net]

Patches item #1717848, was opened at 2007-05-12 21:25
Message generated for change (Comment added) made by vitspec
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743022&aid=1717848&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver 1.2.x
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Victor Gamov (vitspec)
Assigned to: Nobody/Anonymous (nobody)
Summary: MySQL Prepared Statements

Initial Comment:
Hi

file attached introduce MySQL Prepared Statemets API using in mysql module.
"Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed only once."
So I hope it can help OpenSER to be more quickly on SELECT/INSERT/UPDATE when it using (MySQL) DB backend.

To compile this API support you can define new make variable MYSQL_USE_PREPARED_STMT (or simply add it into Makefile) and run make/gmake.

This patch build for 1.2.0
I test it on my openser-1.2.0 and it works fine but more tests needed.
I will try to make code clear ASAP.

Thanks.


----------------------------------------------------------------------

>Comment By: Victor Gamov (vitspec)
Date: 2007-05-12 21:33

Message:
Logged In: YES 
user_id=1625470
Originator: YES

File Added: mysql_ps-patch.tgz

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743022&aid=1717848&group_id=139143