Re: ByteA column retrieved in 31 minutes ...

Hi Andrea,

(2012/07/17 23:46), Andrea Ricci wrote:
> Hi,
> I'm using a 9.0.2 db in a PowerBuilder 12.1 application, connecting to
> it via ODBC driver 09.00.0200.
>
> I have a table with a bytea column:
>
> CREATE TABLE docs
> (
>    blobid character(7) NOT NULL,
>    descript character varying(40),
>    data date,
>    "lock" character(1),
>    ora character(5),
>    parita character(1),
>    tipo character(3),
>    dbvtesto bytea,
>    CONSTRAINT docs_pkey PRIMARY KEY (blobid),
>    CONSTRAINT fk1_docs FOREIGN KEY (blobid)
>        REFERENCES blob (blobid) MATCH SIMPLE
>        ON UPDATE NO ACTION ON DELETE CASCADE
> )
> WITH (
>    OIDS=FALSE
> );
>
>
> When I retrieve via embedded SQL the dbvtesto column (using PK obv.) I
> get it in few seconds if its length is about 10 KB, but I've to wait 31
> minutes (!) if it's about 1 MB.
>
> If someone has a proposal ...

Mylog is a performance killer for this kind of query.
How about disabling Mylog?

regards,
Hiroshi Inoue