Re: Statements parsing from stored procedures

Thanks all for replying to this post. We are taking new path to handle this issue...

The only way to avoid a soft parse is to re-use a statement handle. This can only be done inside the same process (statement handles cannot be shared across processes or across connection handles).

Sample pseudo code:
==
- dbHandle = open DB connection

• sqlHandle = Open and Parse SQL( dbHandle, 'INSERT...' )
• for i = 1 to foo.Count --- Bind Variable( sqlHandle, 'NAME', foo[i].name ) --- Bind Variable( sqlHandle, 'ID', foo[i].id ) --- .. etc. --- result = Execute SQL( sqlHandle )
• end for loop
• close( sqlHandle )
• close( dbHandle ) ==

In the loop the same SQL statement handle is re-used. The statement has already been parsed (hard or soft). It is not parsed again in the loop. Which is great. Received on Thu Apr 20 2006 - 02:22:06 CDT