Luca Mearelli wrote: > Hongli Lai wrote: > In any case using real bind variable would represent a further > optimization step, as it'd allow a fine tuning of which bind variables > vs literal values use in each query.
Agreed. In my tests the _client_ performance impact of using real bind variables instead of relying on cursor_sharing of similar was basically non-existent, but there was some (small, but still some) server improvement. Plus some Oracle query plans worked better (ie., required fewer hints) when constants were left as constants. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-core@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
