On May 25, 2006, at 3:07 PM, Michael A. Schoen wrote:
So I've finally bitten the bullet and patched the AR Oracle adapter to use real OCI bind variables. This has a measurable impact on the client side, and a huge impact on a high volume Oracle server due to the sql hard parses that it saves.
I assume bind variables and prepared statements are orthogonal.
2. Do other db's support a similar concept with a similar benefit? Should this functionality be implemented at a higher level (ie., in the abstract adapter) to make it usable for other dbs?
Yes: the native postgres bindings support bind variables. In any case, we can move the existing behavior to the abstract adapter as a fallback.
As an aside, only the pretty comprehensive AR unit tests make a patch like this even possible to think about. So kudos to everyone on that point.
And kudos to you! Thank you for your conscientious maintainership. jeremy _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
