Re: Guile Interpreter as a Standalone Server

[Volkan YAZICI]

Hi,

On Oct 20 09:45, Neil Jerram wrote:
> Volkan YAZICI <address@hidden> writes:
> >  - Parse & execute faster. (We won't need to create a new process
> >    everytime.)
> 
> Is this for a specific application, out of interest?

Yes, it's for PL/scheme. [http://plscheme.projects.postgresql.org/]

> >  - Cache parse plans.
> 
> I don't understand what this item means.

You know, there're some procedure volatility levels in SQL. For
instance, non-volatile (mmiutable) procedures always return same result
as long as you supply same argument values. (Yes, we've caching for this
in PL/scheme.) For volatile procedures, result depends on lots of
outsource data, therefore its result is undeterminable. But, I had
thought that at least I can make PL/scheme perform better by just
executing the previously cached parse plan (by skipping parsing from
scracth phase) parameters) of a volatile procedure called with exactly
the same arguments.


Regards.