Re: pgadmin horribly slow - Mailing list pgadmin-support

From Dave Page
Subject Re: pgadmin horribly slow
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB104743F@dogbert.vale-housing.co.uk
Whole thread Raw
In response to pgadmin horribly slow  (Erich Titl <erich.titl@think.ch>)
List pgadmin-support
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.titl@think.ch]
> Sent: 17 January 2002 10:30
> To: pgadmin-support@postgresql.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.titl@think.ch
> PGP Fingerprint: BC9A 25BC 3954 3BC8 C024  8D8A B7D4 FF9D 05B8 0A16
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

pgadmin-support by date:

Previous
From: Erich Titl
Date:
Subject: pgadmin horribly slow
Next
From: "Sucker"
Date:
Subject: importing from oracle