> -----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
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.
pgsql-cygwin by date
|Next:||From: Christof Petig||Date: 2001-07-11 11:30:16|
|Subject: Libpq.dll on MinGW, was Re: initdb failure - postgres hangs with 100%
|Previous:||From: Robby Slaughter||Date: 2001-07-10 21:28:45|
|Subject: ODBC calls seem surprisingly slow...|