Thread: Pre-preparing / parsing SQL statements

Hi All,

I remember Tom doing a benchmark that showed postgres spends a lot of 
time parsing SQL statements. There was some mention of implementing a 
sort of ociparse and allowing the pre-parsing and binding of values to 
placeholders in the SQL statement.

I can't seem to find this on the TODO list.  Is anyone working on such a 
thing?  I seem to remember some saying that the FE-BE protocol would 
have to change, so maybe the discussion was stopped there? (*shurg*)

Thank you

Ashley Cambrell

> I remember Tom doing a benchmark that showed postgres spends a lot of 
> time parsing SQL statements. There was some mention of implementing a 
> sort of ociparse and allowing the pre-parsing and binding of values to 
> placeholders in the SQL statement.

I'm very interrested to read more about this. Anyone has URL for this?
Thanks.
> I can't seem to find this on the TODO list.  Is anyone working on such a 
> thing?  I seem to remember some saying that the FE-BE protocol would 
> have to change, so maybe the discussion was stopped there? (*shurg*)

Same remark as above.

-- 
Jean-Paul ARGUDO