Prepared Statements inside stored procedures

[Ivan Smahin]

Hello Bart,

Thursday, July 15, 2010, 12:17:21 AM, you wrote:

> Hi List,

> just wondering if it is possible to use prepared statements inside stored procedures.
> If not, why not (= feature request)

> Certainly when looping over a cursor and using the cursor for
> building new queries, the speed of execution would rise because the
> prepared statement would be recognized by the parser and could be
> picked up (from the second pass on) from the query pool ?

> Or am I misunderstanding ?

Valentina  do  it  self  if possible. It keeps the trees (which parser
builds for query) in the pool and tries to find such parsed tree for
each new query in the pool first. So such feature is redundant.


> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com