Hi, I got several questions on AR adapters implementation: 1. For SqlServer/Oracle, SQL queries are built by concatenation, and there is no use of parameters. Especially for Oracle, this is very bad, no optimization can be done. Is there a reason for that? Does anybody plan to fix that? 2. When updating a model, _all_ columns are updated. Why not only the diff is updated? Using blob/cblob, it really goes to bad performance. Thank you, Jean-Etienne - http://www.novAgora.hu -- Posted via http://www.ruby-forum.com/.
On 6/29/06, Jean-Etienne <etienne.durand@woa.hu> wrote:> 1. For SqlServer/Oracle, SQL queries are built by concatenation, and > there is no use of parameters. Especially for Oracle, this is very bad, > no optimization can be done. Is there a reason for that? Does anybody > plan to fix that?Someone is working on it. Search the archives.> 2. When updating a model, _all_ columns are updated. Why not only the > diff is updated? Using blob/cblob, it really goes to bad performance.Validations at the application don''t guarantee consistancy unless the entire record is updated each time. If validations were in the database (in addition to or instead of the application), updating only modified fields would be possible, but as far as I know there are no plans to do that.
Jeremy Evans wrote:> On 6/29/06, Jean-Etienne <etienne.durand@woa.hu> wrote: >> 1. For SqlServer/Oracle, SQL queries are built by concatenation, and >> there is no use of parameters. Especially for Oracle, this is very bad, >> no optimization can be done. Is there a reason for that? Does anybody >> plan to fix that? > > Someone is working on it. Search the archives. > >> 2. When updating a model, _all_ columns are updated. Why not only the >> diff is updated? Using blob/cblob, it really goes to bad performance. > > Validations at the application don''t guarantee consistancy unless the > entire record is updated each time. If validations were in the > database (in addition to or instead of the application), updating only > modified fields would be possible, but as far as I know there are no > plans to do that.Thank you Jeremy. Anyone to point me the link for 1/ ? -- Posted via http://www.ruby-forum.com/.
Wilson Bilkovich
2006-Jul-02 02:04 UTC
[Rails] Re: Questions on ActiveRecord implementation
On 6/30/06, Jean-Etienne <etienne.durand@woa.hu> wrote:> Jeremy Evans wrote: > > On 6/29/06, Jean-Etienne <etienne.durand@woa.hu> wrote: > >> 1. For SqlServer/Oracle, SQL queries are built by concatenation, and > >> there is no use of parameters. Especially for Oracle, this is very bad, > >> no optimization can be done. Is there a reason for that? Does anybody > >> plan to fix that? > > > > Someone is working on it. Search the archives. > > > >> 2. When updating a model, _all_ columns are updated. Why not only the > >> diff is updated? Using blob/cblob, it really goes to bad performance. > > > > Validations at the application don''t guarantee consistancy unless the > > entire record is updated each time. If validations were in the > > database (in addition to or instead of the application), updating only > > modified fields would be possible, but as far as I know there are no > > plans to do that. > > > Thank you Jeremy. Anyone to point me the link for 1/ ? >The discussion starts here, if you haven''t found it already: http://wrath.rubyonrails.org/pipermail/rails-core/2006-May/001522.html --Wilson.