openerp-expert-framework team mailing list archive

[Georges Racinet <gracinet@xxxxxxxxx>]

Hi,

On 04/26/2012 12:04 PM, "Lionel Sausin, de la part de l'équipe 
informatique Numérigraphe" wrote:
> Le 26/04/2012 09:45, Valentin LAB a écrit :
> > Some questions on the state of some part of the new API:
> >
> > - will reference type field value be converted to full object on the
> > fly (as a browse object does for many2one relation for example) ? If
> > no, what is the reason keeping this non-abstracted ?
> >
> > - will "_order" attribute be defined in the data model ? (I feel this
> > should go in the form descriptor, and have nothing to do in the data
> > model...)
> Having an order defined at the data model level let us get ordered
> browse records, which can be quite handy at times. I don't think it
> weighs a lot on the database either.

In general not, but in some cases, it can become a terrible burden.
Same thing for count (maybe even worse). Both impose a full iteration on 
the select results.

I believe ORDER BY to be rather easy to disable since v6, though (well, 
IIRC). Not sure at all about COUNT (GTK client asked for it systematically)