[DB-SIG] Databases chapter for Python on Windows book

M.-A. Lemburg mal@lemburg.com
Tue, 06 Jul 1999 18:00:12 +0200

Andy Robinson wrote:
> As some of you know, Mark Hammona dna I are putting the finishing
> touches to "Python Programming for Win32", due from O'Reilly this
> autumn.  I'm doing the database chapter.  I hope you'll forgive me for
> asking for answers I could probably dig out with a lot of research,
> but I have a load of other subjects to research too.
> The book needs to 'punch the right buttons' for corporate developers
> and IT managers and I am pushing the ideas of data cleaning and
> transformation scripts in Python.
> Q1.  I know the ODBC API and the Python DB API provide support for
> precompiled SQL statements.  What I don't know is which databases and
> drivers actually use these to get better performance.  Can anyone help
> out on this?

mxODBC caches the last execute string on every cursor. If you

stuff = 'select ... '
for i in range(10):

mxODBC will prepare the statement once and then reuse it for
all subsequent calls.

Marc-Andre Lemburg
Y2000:                                                   178 days left
Business:                                      http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/