Forum OpenACS Q&A: Response to Saving execution plan with OACS 4 API?

Collapse
2: Response to Saving execution plan with OACS 4 API? (response to 1)
Posted by Jonathan Ellis on 01/04/02 11:04 PM
it's more dependant on your DB than the ACS... basically the DB can re-use the execution plan if (a) it is in a stored proc or (b) it is executed with bind variables.  The PG driver doesn't support bind variables, but the Oracle one does.