MironAtHome commented on issue #1990:
URL: https://github.com/apache/age/issues/1990#issuecomment-2257230039
@jrgemignani How hard would it be to make this function
```
CREATE FUNCTION ag_catalog.age_prepare_cypher(cstring, cstring)
RETURNS boolean
LANGUAGE c
STABLE
PARALLEL SAFE
AS 'MODULE_PATHNAME';
```
return an handle to an prepared statement, so that it can be called using
something like
`select * from ag_catalog.age_execute_prepared_cypher(handle, parameter_map)
as t(a agtype);`
many times in a loop. The advantage being fairly obvious, on my mind. Once
compiled statement called in the loop in theory should bring an significant
performance improvement.
The question regarding multiple threads will still remains. It's not related
to multiple thread invocation. Only retention of execution plan using handle
variable.
@ishaan812 I apologies for barging into question with my own, somewhat
unrelated sideline. Hope it is accepted in vein of caring to make age graph
database better :)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
