Forum OpenACS Q&A: Re: Tuning a query with CR joins

Collapse
4: Re: Tuning a query with CR joins (response to 1)
Posted by Peter Marklund on 02/17/03 06:05 PM
Jeff,
well what can I say...you are my god! The query went from 1000+ ms to 160 ms when increasing the GEQO_THRESHOLD from 5 to 15!

Admittedly the query a still a on the slow side, but it's no longer a show stopper.

Cheers

Peter