gareth williams

problem was purely the size of the sql statement wouldn't fit.

We had a patch to resolve and taught the developer how to write sensible
queries.

Is this your problem?

Cheers

Gareth

-----Original Message-----
From: Karl & Betty Schendel [mailto:schendel@kbcomputer.com]
Sent: 30 August 2005 21:56
To: info-ingres@cariboulake.com
Subject: Re: [Info-ingres] DBMS Server problems / Optimizer memory


At 1:31 PM -0700 8/30/2005, Steve McElhinney wrote:

I'd agree with a bit more stack and maybe 2x or 3x the OPF memory.
I doubt that QSF memory has anything to do with it, but doubling
the size won't hurt anything.

OPF is supposed to deal nicely with running out of memory, but it doesn't
always, I guess. Or, you're falling off the end of a stack, which is
almost guaranteed to produce weird random errors. That's usually
(not always) reproducible in isolation, though.

One other thing: take a look at opf_active_limit and opf_maxmemf.
opf_active_limit defaulted a bit higher than usually necessary in 2.6,
unless your load issues lots of nasty simultaneous queries.
If you really need opf_active_limit higher than maybe 10 or so, letting
any one of them take up to 50% of opf_memory (which is the opf_maxmemf
default) is probably being optimistic; in that case you might drop
opf_maxmemf to 33% or 25% (or even less in extreme cases).


Karl
_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailm...py/info-ingres
Cymraeg:- Mae'r neges hon yn gyfrinachol.Os nad chi yw'r derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig â rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o
eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na chorff cysylltiedig.

Cofiwch fod yn ymwybodol ei bod yn
bosibl y bydd disgwyl i Ymddiriedolaeth GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu ohebiaeth a dderbynnir, yn
unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 2000. I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio at wefan
Ymddiriedolaeth GIG Bro Morgannwg ar www.bromor-tr.wales.nhs.uk

English:- This message is confidential. If you are not the intended recipient of the message then please notify the sender immediately.
Any of the statements or comments made above should be regarded as personal and not necessarily those of Bro Morgannwg NHS Trust, any
constituent part or connected body.

Please be aware that, under the terms of the Freedom of Information Act 2000, Bro Morgannwg NHS Trust may be required to make public the
content of any emails or correspondence received. For further information on Freedom of Information, please refer to the Bro Morgannwg NHS
Trust website at www.bromor-tr.wales.nhs.uk.