Re: [GENERAL] Query caching absent "query caching"

2012-11-25 Thread Pavel Stehule
2012/11/25 Bexley Hall : > Hi Pavel, > > On 11/24/2012 9:47 PM, Pavel Stehule wrote: >> >> Hello >> >> you can try use plperl as cache >> >> >> http://okbob.blogspot.cz/2007/12/using-shared-as-table-cache-in-plperl.html > > > But how is this any different than just creating a named/shared > table m

Re: [GENERAL] Query caching absent "query caching"

2012-11-25 Thread Bexley Hall
Hi Kevin, On 11/25/2012 8:10 AM, Kevin Grittner wrote: Bexley Hall wrote: Specifically, I have several computationally expensive functions that derive their results from specific values of these base types. *Solely*. (For example, area() when applied to a given "circle" always yields the same

Re: [GENERAL] Query caching absent "query caching"

2012-11-25 Thread Bexley Hall
Hi Pavel, On 11/24/2012 9:47 PM, Pavel Stehule wrote: Hello you can try use plperl as cache http://okbob.blogspot.cz/2007/12/using-shared-as-table-cache-in-plperl.html But how is this any different than just creating a named/shared table manually? And, how do further/additional accesses (by

Re: [GENERAL] Query caching absent "query caching"

2012-11-25 Thread Kevin Grittner
Bexley Hall wrote: > Specifically, I have several computationally expensive > functions that derive their results from specific values of > these base types. *Solely*. (For example, area() when > applied to a given "circle" always yields the same result... > though this is a trivial/inexpensive fu

Re: [GENERAL] Query caching absent "query caching"

2012-11-24 Thread Pavel Stehule
Hello you can try use plperl as cache http://okbob.blogspot.cz/2007/12/using-shared-as-table-cache-in-plperl.html Regards Pavel Stehule 2012/11/25 Bexley Hall : > Hi, > > In the absence of query caching AND NOT WANTING TO FORCE > THE APPLICATION TO DO SO EXPLICITLY, I'm looking for ideas > as