Questions on ActiveRecord implementation

Rails
1

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

2

On 6/29/06, Jean-Etienne [email protected] 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.

  1. 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.

3

Jeremy E. wrote:

On 6/29/06, Jean-Etienne [email protected] 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.

  1. 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/ ?

4

On 6/30/06, Jean-Etienne [email protected] wrote:

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.