Alexey Verkhovsky wrote: >> and they would see a noticable gain only when these prepared statements >> were reused for multiple queries. > It's the same with Oracle. Prepared statement is merely a way to avoid > hitting SQL parser and query optimizer.
I've done some testing w/ Oracle, and a very significant gain comes from simply using real bind variables. Caching the prepared statements in the client doesn't matter much at all, presuming you're going to have multiple clients. But the use of real bind variables allows Oracle itself to cache the statements and avoid multiple hard parses. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
