Re: pgadmin horribly slow

Hi Erich,

pgAdmin doesn't work directly on the ODBC API in the main so the log entry
you're getting below is almost certainly coming from Microsoft ADO of which
we can do little to fix.

As for the speed issue, the ODBC tracing that created the log below is
renowned for slowing down the system horrendously. Make sure tracing is
turned off in the ODBC driver manager. You should also ensure that the log
level under Tools -> Options is not set to Debug or Full Debug.

Regards, Dave.

> -----Original Message-----
> From: Erich Titl [mailto:erich(dot)titl(at)think(dot)ch]
> Sent: 17 January 2002 10:30
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] pgadmin horribly slow
>
>
> Hi
>
> here is some more information on the subject
>
> This is what sql.log on the Win2k box says:
>
> pgAdmin2 3f8-f8 EXIT SQLGetData with return code 1
> (SQL_SUCCESS_WITH_INFO)
> HSTMT 024E3570
> UWORD 2
> SWORD 1 <SQL_C_CHAR>
> PTR 0x0012F054
> SQLLEN 0
> SQLLEN * 0x0012F01C (17)
>
> DIAG [01004] The buffer was too small for
> the GetData. (-2)
>
> Which buffer is too small here
>
> Thanks
>
> Erich
>
> THINK
> Püntenstrasse 39
> 8143 Stallikon
> mailto:erich(dot)titl(at)think(dot)ch
> PGP Fingerprint: BC9A 25BC 3954 3BC8 C024 8D8A B7D4 FF9D 05B8 0A16
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>