Обсуждение: pgadmin horribly slow

Поиск
Список
Период
Сортировка

pgadmin horribly slow

От
Erich Titl
Дата:
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


Re: pgadmin horribly slow

От
Dave Page
Дата:
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
>