Comment 8 for bug 1223243

Revision history for this message
Guewen Baconnier @ Camptocamp (gbaconnier-c2c) wrote : Re: [Bug 1223243] Re: [7.0] Impossible to import a csv file with 30000 account move lines

Yes, that's why I specifically measured the ORM part and ignored the import
part.

The problem here is of course in the creation / write of move lines.
Le 10 sept. 2013 15:30, "Xavier (Open ERP)" <email address hidden> a
écrit :

> > only the call to ir_model_data._update(), not taking into account the
> import stuff around
>
> The import munging and analysis takes very little time, it's always the
> creation of complex objects in openerp which takes CPU time.
>
> There's a test case in the server which imports ~1000 contacts (calling
> Model.load directly, not going through the import parsing and munging)
> and takes 25s on my machine, 24.6s being in res.partner's create or one
> of its callees. The problem is of course that openerp's object creation
> can be arbitrarily complex, and for some objects it does a lot of work
> checking stuff around or creating related and sub-objects, the import
> process itself can't do much about that.
>
> --
> You received this bug notification because you are subscribed to OpenERP
> Project Group.
> https://bugs.launchpad.net/bugs/1223243
>
> Title:
> [7.0] Impossible to import a csv file with 30000 account move lines
>
> Status in OpenERP Server:
> New
>
> Bug description:
> Hello,
>
> I need to import accounting journal entries in mass (about 170 000 mvl
> over 10 months).
>
> I want to use the standard OpenERP CSV import functionnalty but I face
> a error with only 30 000 mvl .
>
> To reproduce :
> - connect a runbot (build 19601 in my case)
> - create a bas DB with only accounting and basic Chart of account
> installed
> - In the settings, check t the box to allow csv import
> - Go to Accounting / Journal Entries / Journal Entries and import the
> file attached to this bug report
>
> -> Result : OpenERP is not even able to display the 10 first lines as
> usual. If you open the Chrome web browser console, you see the error
> 'Request entity too large'). See attached my printscreen.
>
> I consider such a low capacity of import a bug since for it is not
> rare, especially for new implementation to have to import past
> accounting entries... and 30000 move lines is not much.
>
> What is you position on this point please ?
>
> Frederic Clementi
> Camptocamp SA
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-server/+bug/1223243/+subscriptions
>