[Info-ingres] Very slow help table response

[Martin Bowes]

Ta, that did the trick.

Missing stats on iistatistics...is that irony or what?

Now have help table in sub second response.

Marty

-----Original Message-----
From: Roy Hann [mailto:specially at processed.almost.meat] 
Sent: 27 July 2017 11:39
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Very slow help table response

Martin Bowes wrote:

> Hi All,
>
> Ingres Vector. VW 5.0.0 (a64.lnx/402) + p40205
>
> We have a database in which a help table takes some 23 seconds to 
> respond...which is a little embarrassing for an otherwise 
> lickety-split slicker than snot type installation.
>
> I've used II_EMBED_SET printqry to find where its slow and have found (FWIW):
> Query text:
>   execute query (qrtabhlp5) 'val_real' 'ace'
> Query Send Time:       27-Jul-2017 09:43:46.39
> Query Response Time:   27-Jul-2017 09:44:07.68
> Response CPU Time:     93
> Qry End CPU Time:      93
>
> I've run a sysmod over the database and the slow response persists.
>
> Anyone got any ideas?

If you set trace point qs506 to invalidate the cached query plans then run it again, do you get to see the actual query?

Roy
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres