Blair Zajac wrote:
To work around lack of bind variables, our Oracle DBA has enabled cursor sharing, which is an extra pass that Oracle does over the SQL. So it'll take two separate SQL statements, say
Yep, that's what we're doing right now in production as well. The biggest issues are: a) it's still a chunk of extra work for the already overworked db, and b) with cursor_sharing set to `similar`, any sql statements with non-equality operators don't share properly -- and setting it to `exact` leads to other issues.
_______________________________________________ Rails-core mailing list [email protected] http://lists.rubyonrails.org/mailman/listinfo/rails-core
