MS SQL Server/ODBC package for Python

[Francois Lepoutre]

Hi Peter

> Running your benchmark, I ran into a couple of interesting points.
> Using mx.ODBC, my times were 0.54 seconds and 6.56 seconds
> respectively, while using adodbapi my results are 3.55 seconds and 25.9
> seconds respectively.  mx.ODBC is faster with the simple query you
> provide.

We agree on figures at this stage :)

> Next I modified the benchmark to reflect my particular circumstances
> more accurately [...] reduce the number of iterations from 100
> to 10.  Since there are 128000 records in the main table, the wait for
> 100 iterations was too long for my patience.  Under these
> circumstances, mx.ODBC's numbers are 188.49 seconds and 377.56 seconds
> respectively, and adodbapi's times are 111.15 seconds and 223.55
> seconds respectively.

This is an interesting feedback. It looks like both middleware have
their distinct value and distinct set of advantages.

I'll definitely review my judgment on ADO!

> My first wall-clock impressions are obvious exaggerations of reality,
> for which I duly apologize to all.  However, adodbapi did prove to be
> faster in my admittedly very wacky common use case.  Slower to connect,
> but faster to run a substantial query.

> Comments?  Questions?  Suggestions for improvement?

Based on your results, my feeling is that mx.ODBC remains a solution
of choice for db-support behing web services "à la mod_python"
where connection time is essential whilst adodbapi would be the
definite winner when it comes to typical db-intensive win32-based
applications (such as wxpython-based ones).

Regards to you

Francois