[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-12-2008 08:36 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-12-08 08:36  
---------------------------------------------------------------------- 
I hereby request that this patch be committed, for it really helps lowering
the stress on the system in a very high load scenario. Also, we need to do
the same for cdr_odbc, or rewrite cdr_tds, which does not compile with the
latest version of freetds. Either or. SQLExecDirect()  is the way to to. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
01-12-08 08:36  falves11       Note Added: 0076796                          
======================================================================