RE: ODBC calls seem surprisingly slow...

> -----Original Message-----
> From: Robby Slaughter [mailto:webmaster(at)robbyslaughter(dot)com]
> Sent: 10 July 2001 22:29
> Cc: Pgsql-Cygwin
> Subject: [CYGWIN] ODBC calls seem surprisingly slow...
>
>
> 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?

I personally find that Cygwin PostgreSQL is only really fast enough as a
(very) convenient development platform (<ducks> sorry Jason! But it is
*very* useful and appreciated). Having said that, I don't find it anything
like as slow as you imply. Some common problems:

1) Ensure that the ODBC driver is not in Debug mode (i.e. set
HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\PostgreSQL\Debug = 0 using
regedit).

2) In the ODBC Driver Manager, make sure that ODBC Tracing is switched off -
this creates a huge logfile and can slow the system tremendously.

hth, regards, Dave.