From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'webmaster(at)robbyslaughter(dot)com'" <webmaster(at)robbyslaughter(dot)com> |
Cc: | Pgsql-Cygwin <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | RE: ODBC calls seem surprisingly slow... |
Date: | 2001-07-11 07:32:23 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D61A2CF3@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Christof Petig | 2001-07-11 11:30:16 | Libpq.dll on MinGW, was Re: initdb failure - postgres hangs with 100% CPU |
Previous Message | Robby Slaughter | 2001-07-10 21:28:45 | ODBC calls seem surprisingly slow... |