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 ! :::: -- http://mail.python.org/mailman/listinfo/python-list
