[asterisk-bugs] [Asterisk 0010723]: [patch] Convert func_odbc to use SQLExecDirect() for speed

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=10723 
====================================================================== 
Reported By:                mnicholson
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   10723
Category:                   Functions/func_odbc
Reproducibility:            N/A
Severity:                   tweak
Priority:                   normal
Status:                     ready for testing
Asterisk Version:            SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 82391 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             09-14-2007 11:48 CDT
Last Modified:              01-09-2008 17:53 CST
====================================================================== 
Summary:                    [patch] Convert func_odbc to use SQLExecDirect() for
speed
Description: 
This patch converts func_odbc to use SQLExecDirect() instead of
SQLPrepare() then SQLExecute().  This patch depends on but 10722.  See bug
10722 for the reasoning behind this change.
====================================================================== 

---------------------------------------------------------------------- 
 falves11 - 01-09-08 17:53  
---------------------------------------------------------------------- 
THIS iS FANTASTIC!!!!
I recommend this patch to be saved in trunk right away. However, it begs
for a similar modification to cdr_odbc, since every call saved to the
databas uses 3 network calls versus one.

I tested the code with hundreds of simultaneus call attempts and it works. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
01-09-08 17:53  falves11       Note Added: 0076606                          
======================================================================