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

[SourceForge.net]

Patches item #1717848, was opened at 2007-05-12 17:25
Message generated for change (Comment added) made by nobody
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 devel
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: Nobody/Anonymous (nobody)
Date: 2009-03-13 21:04

Message:
Hi Henning,

any news on this feature, it seems to be already implemented in OpenSIPS,

why not in Kamailio?

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

Comment By: Henning Westerholt (henningw)
Date: 2007-10-05 15:29

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

The patch could not be applied anymore to the trunk. 

Cheers,

Henning

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

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