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

SourceForge.net noreply at sourceforge.net
Thu Sep 27 09:54:50 CEST 2007


Patches item #1717848, was opened at 2007-05-12 17:25
Message generated for change (Settings changed) made by henningw
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: Henning Westerholt (henningw)
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-18 09:18

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

Hi Henning

I devel and test this patch on mysql-server-4.1.3
On next week I'll try to test it on 5.1.16

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

Comment By: Henning Westerholt (henningw)
Date: 2007-05-18 08:24

Message:
Logged In: YES 
user_id=337916
Originator: NO

Hello Victor,

according to the mysql documentation, prepared statements are available
starting from version 4.1. This should be ok, as most of the distribution
ships at least 4.1 now. Are there any stabilty problems with 4.1 with this
feature? What version do you use?

I'll take next week a closer look to your patch.

Henning

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

Comment By: Victor Gamov (vitspec)
Date: 2007-05-17 19:32

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

File Added: mysql_ps-patch.tgz

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

Comment By: Victor Gamov (vitspec)
Date: 2007-05-12 17: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



More information about the Devel mailing list