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