[egenix-users] Speeding up ODBC Connection
mal at egenix.com
Fri Sep 12 23:23:45 CEST 2008
On 2008-09-12 21:49, Minh-Long Pham wrote:
> I'm running mxODBC on a machine that remotely connects to the server,
> and when I'm executing scripts, it takes 20 minutes longer than it would
> on the server itself.
> Is there any way to speed up the connection?
Without more details about the used database backend, server and client
platforms as well as ODBC driver, there's nothing much we can do to
Some drivers allow tweaking the way pre-fetching and network packet
sizes are handled, thus reducing the number of network round-trips.
You might also want to check whether mxODBC Connect is faster for your
Professional Python Services directly from the Source (#1, Sep 12 2008)
>>> 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,MacOSX for free ! ::::
eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
More information about the egenix-users