Pre-preparing / parsing SQL statements

Started by Ashley Cambrellalmost 24 years ago2 messages
#1Ashley Cambrell
ash@freaky-namuh.com

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

#2Jean-Paul ARGUDO
jean-paul.argudo@idealx.com
In reply to: Ashley Cambrell (#1)
Re: Pre-preparing / parsing SQL statements

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