Patches item #1717848, was opened at 2007-05-12 17:25 Message generated for change (Comment added) 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 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: 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 _______________________________________________ Devel mailing list Devel@openser.org http://openser.org/cgi-bin/mailman/listinfo/devel
