| Subject | Re: [firebird-support] Bind Variables and Performance |
|---|---|
| Author | chee hee |
| Post date | 2003-07-10T10:05:25Z |
I agree with what Helen has said on bind variables, but would like to add on to it.
What actually benefit from using bind variable in Oracle is it doesn't need to re-parse the SQL stmt. It is already in the cache. Parsing is an expensive operation and thus using bind variable will save a lot of time.
BTW, does Firebird has this feature (using parsed stmt from cache) ?
cm
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
[Non-text portions of this message have been removed]
What actually benefit from using bind variable in Oracle is it doesn't need to re-parse the SQL stmt. It is already in the cache. Parsing is an expensive operation and thus using bind variable will save a lot of time.
BTW, does Firebird has this feature (using parsed stmt from cache) ?
cm
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
[Non-text portions of this message have been removed]