Re: MS SQL Server/ODBC package for Python

> > Next I modified the benchmark to reflect my particular circumstances > > more accurately (?Maybe? Comments invited). I changed the query to > > one of the queries in regular use in my application. This query > > selects 26 columns from 3 joined tables, with a where clause "where > > f476 = ?

Re: MS SQL Server/ODBC package for Python

Peter Herndon wrote: :) Knock away, as my info isn't scientific anyway. In my case, ASA is *not* local. The db is running on a 500MHz x 2 server with 768MB RAM, over 100BaseT connection. That same server is also running the MSSQL instance, and IIS. Running your benchmark, I ran into a couple of

Re: MS SQL Server/ODBC package for Python

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 figu

Re: MS SQL Server/ODBC package for Python

I switched around the order, both in the actual application and in my tests as replied to Francois Lepoutre above. Results were consistent, after the first run of any given test, which unsurprisingly took a bit longer. -- http://mail.python.org/mailman/listinfo/python-list

Re: MS SQL Server/ODBC package for Python

:) Knock away, as my info isn't scientific anyway. In my case, ASA is *not* local. The db is running on a 500MHz x 2 server with 768MB RAM, over 100BaseT connection. That same server is also running the MSSQL instance, and IIS. Running your benchmark, I ran into a couple of interesting points.

Re: MS SQL Server/ODBC package for Python

Peter, May my I apologize for knocking against your information, as well. > For what it is worth, my experience is as follows: Using a PIII > 550MHz, 256MB RAM, running WinNT 4.0 and Python 2.3.4 and connecting > to a Sybase Adaptive Server Anywhere 8.0 database, mx.ODBC took > approximately 8 wal

Re: MS SQL Server/ODBC package for Python

Marc-Andre, I apologize for knocking against something that is part of your livelihood, I hadn't thought about that aspect before I posted. In my experience though, adodbapi was much faster. However, I have done no benchmarks, my situation is likely pathological, and I wouldn't be able to build o

Re: MS SQL Server/ODBC package for Python

[EMAIL PROTECTED] wrote: > I do have a standard install of Python as well as Plone. Can you have two? > I have run the mxInstaller for both instances however, whether I run > the ide from my standard install or my plone install the pythonpath is the > same (ie c:\...\plone 2\python). My mach

Re: MS SQL Server/ODBC package for Python

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 seco

Re: MS SQL Server/ODBC package for Python

Another option is adodbapi, which in my experience is much faster than mx.ODBC. 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,

Re: MS SQL Server/ODBC package for Python

mail.com>cc: python-list@python.org Subject: Re: MS SQL Server/ODBC package for Python 15/0

Re: MS SQL Server/ODBC package for Python

On 4/15/05, Graham <[EMAIL PROTECTED]> wrote: > Thanks Simon > I have just installed mxODBC and tried one of their samples. > Am getting an error on trying to import mx.ODBC > > ImportError: No module named mx.ODBC > > After the install the mx folder has been place in my C:\Program Files\Plon

Re: MS SQL Server/ODBC package for Python

Thanks Simon I have just installed mxODBC and tried one of their samples. Am getting an error on trying to import mx.ODBC ImportError: No module named mx.ODBC After the install the mx folder has been place in my C:\Program Files\Plone 2\Python\lib\site-packages folder however when I browse th

Re: MS SQL Server/ODBC package for Python

On 4/15/05, Graham <[EMAIL PROTECTED]> wrote: > I need a SQL Server or ODBC package for Python. Can anyone help please? > Have search the Python packages under Database and there is no reference to > either SQL Server or ODBC. Top of the line is probably mxODBC (

MS SQL Server/ODBC package for Python

I need a SQL Server or ODBC package for Python. Can anyone help please? Have search the Python packages under Database and there is no reference to either SQL Server or ODBC. Thanks Graham -- http://mail.python.org/mailman/listinfo/python-list