Skip site navigation (1) Skip section navigation (2)

Re: Is ODBC that slow?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is ODBC that slow?
Date: 2006-10-21 02:32:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Carlo Stonebanks wrote:
> Our Windows-based db server has to integrate with users that work regularily 
> with Access.When attempting to import user's data from Access MDB files to 
> PostgreSQL, we try on eof two things: either import using EMS SQL Manager's 
> Data Import from Access utility, or export from Access to Postgresql via an 
> odbc-based connectionin both cases, the performance is just awful. 
> Performance with Tcl's native postgres driver seems rather fine running from 
> Windows a Windows client, BTW.
> ODBC is often blamed for this sort of thing - I have the  8.01.02 release 
> dated 2006.01.31. Everything appears to be at its default setting.

Try Command Prompt's ODBC driver.  Lately it has been measured to be
consistently faster than psqlODBC.

Alvaro Herrera                      
The PostgreSQL Company - Command Prompt, Inc.

In response to


pgsql-performance by date

Next:From: Merlin MoncureDate: 2006-10-21 02:39:31
Subject: Re: Slow functional indexes?
Previous:From: Merlin MoncureDate: 2006-10-21 01:11:14
Subject: Re: Best COPY Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group