← Back to team overview

openerp-expert-framework team mailing list archive

Re: Bulk load / import data

 

On 06/03/2013 11:49 AM, Daniel Reis wrote:

Hello Daniel!

https://doc.openerp.com/trunk/server/api_models/

create(cr, user, vals, context=None)[source]
Create *a new record* for the model.

This seems to me to be the bottleneck.

It would be great to be able to create multiple records at once -
example to create all invoice lines of an invoice using one statement

this probably would avoid recomputing invoice totals etc. for each line. (my assumption as the time to complete a transaction increases dramatically and not linear with the number of lines)

but it might be beyond the scope of your project to provide a function (list of dictionaries)
create_bulk(cr, user, [vals1, vals2....] .....

just my 2c
Hello all,

I'm in contact with the creator and maintainer of the Pentaho Kettle OpenERP Steps, and we'll be working on some improvements for it.

One if the issues is server Load method performance.

I'm considering developing an alternative load method, providing a bulk load like capability: it would be perfectly OK for this to skip things like ACL and record rule checks, or many2one reconnects by Name.

There are some design decisions here, so I figured that it could be a good idea to ask for ideas here.

Any opinions, advice, suggestions or help is appreciated.


Regards
Daniel Reis



_______________________________________________
Mailing list: https://launchpad.net/~openerp-expert-framework
Post to     : openerp-expert-framework@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~openerp-expert-framework
More help   : https://help.launchpad.net/ListHelp


References