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

Re: Slow query through ODBC

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Arnaud Lesauvage <thewild(at)free(dot)fr>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Slow query through ODBC
Date: 2006-01-24 21:10:08
Message-ID: 20060124211008.GA31985@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
Tue, Jan 24, 2006 at 04:47:04PM +0100, Arnaud Lesauvage wrote:
> I went on with my investigations.
> 
> I now believe that the problem lies within the network dialog 
> (between my client and my server).
> If I transfer this table on my workstation (I have a local 
> postgresql installation too), the query runs blindingly fast (less 
> than 1 sec).
> I don't understand what the problem could be though.
> 
> This thread in the mailing list archive looks like the problem 
> mentionned is the same as mine, but they don't really mention a fix :
> http://archives.postgresql.org/pgsql-performance/2005-06/msg00593.php
> 
> My server is on the LAN, so bandwidth cannot be a problem.
> Furthermore, I just migrated from a MySQL 5.0 server. The exact 
> same query on this MySQL server, through MyODBC, took less than 1 
> second too, so my network is not the problem.
> 
> Are there specific client/server protocol tuning parameters ?

I know about nothing like that.

> Have you ever heard of such issues ?

No, I haven't heard it with 08.01 yet.

Regards,

Luf

P.S. I reply mainly for Cc: pgsql-odbc - more heads more knowledge ;-)

In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2006-01-24 21:22:32
Subject: Re: Odbcapi30.c - 64 bit compiler warning cleanup
Previous:From: Ludek FinstrleDate: 2006-01-24 20:39:29
Subject: Re: Odbcapi30.c - 64 bit compiler warning cleanup

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