MS SQL Server/ODBC package for Python

[M.-A. Lemburg]

Peter Herndon wrote:
> Another option is adodbapi, which in my experience is much faster than
> mx.ODBC.  

Much faster ?

See http://www.microsoft.com/technet/prodtechnol/windows2000serv/technologies/iis/reskit/iischp7.mspx
and scroll down to Table 7.1:

      Table 7.1 TPS (transactions per second) Per Number of Threads by MDAC Technology
      Threads 	1 	2 	5 	10 	20 	50
      ODBC 	66.37 	146.28 	350.46 	626.76 	900.24 	859.91
      OLEDB 	67.30 	141.92 	326.19 	590.57 	794.91 	715.78
      OLEDB 2.0	61.73 	126.93 	297.29 	506.75 	575.35 	526.61
      ADO 2.0 	51.24 	108.12 	240.91 	377.30 	361.26 	310.34

> You can find it at http://adodbapi.sourceforge.net , and it
> is Windows-only.  There's also http://pymssql.sourceforge.net, which is
> cross-platform using FreeTDS and unixodbc on *nix.  I haven't any
> experience with it, though.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Apr 15 2005)
>>> 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,FreeBSD for free ! ::::