Prepared Statements inside stored procedures

[Bart Pietercil]

One more thing cleared ;-)
thx, Ivan

Bart Pietercil
CTO Cognosis NV



On 15 Jul 2010, at 10:21, Ivan Smahin wrote:

> 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
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina