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

ODBC calls seem surprisingly slow...

From: "Robby Slaughter" <webmaster(at)robbyslaughter(dot)com>
To:
Cc: "Pgsql-Cygwin" <pgsql-cygwin(at)postgresql(dot)org>
Subject: ODBC calls seem surprisingly slow...
Date: 2001-07-10 21:28:45
Message-ID: EPEHLKLEHAHLONFOKNHNAEJKDCAA.webmaster@robbyslaughter.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
Cygwin folks,

My database calls seem to be VERY slow---10 seconds for a single
query that returns a handful of records.

"select version()" yields:

 PostgreSQL 7.1.2 on i686-pc-cygwin, compiled by GCC 2.95.3-4

I am actually running to ASP pages but calls via Access seem
to be having the same problem.  However, typing the same queries 
into the psql interpreter generates snappy responses. 

So, my question is: is this just the nature of the beast? Is
there probably a particular layer (ipc-daemon, odbc driver, 
or otherwise) which is particularly at fault? Has anyone else
experienced this issue?

Thanks in advance. 

-Robby Slaughter


In response to

pgsql-cygwin by date

Next:From: Dave PageDate: 2001-07-11 07:32:23
Subject: RE: ODBC calls seem surprisingly slow...
Previous:From: Jason TishlerDate: 2001-07-10 20:43:28
Subject: Re: initdb failure - postgres hangs with 100% CPU

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