[egenix-users] mxODBC Cursor Unicode issue with method executedirect().

Charlie Clark charlie at egenix.com
Tue Aug 7 16:54:42 CEST 2007

Am 07.08.2007, 15:26 Uhr, schrieb Cliff Xuan  
<Cliff.Xuan at artsalliancemedia.com>:

> One questions on this:
> What does 'prepare step' mean?

Most database engines allow sql statements to be "prepared", ie. parsed,  
and the parameters passed in separately and handled by the database ODBC  
driver and not Python. For repetitive queries with different parameters  
this can mean a significant difference in performance. As the  
documentation says there may be cases where the database ODBC driver  
doesn't support this or isn't very efficient and executedirect() may,  
therefore, be preferable. I don't think you should need to use  
executedirect() with MS SQL.

Charlie Clark

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::

     eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
     D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
            Registered at Amtsgericht Duesseldorf: HRB 46611

More information about the egenix-users mailing list