Skip to Content
This question has been flagged
createormmass11
1 Reply
2521 Views
Avatar
Yann MOTTE

Hello

We have a job which aims at creating many ( > 500) object from a wizard. Those objects are from a custom model.
Creating each object and writing it to database is very slow; is it possible to prepare a dict of values et ask Odoo ORM to create every objects with only one DB call ?

Any help will be useful, thank you, community, by advance

Lionel (e-COSI)

Avatar
Discard
Avatar
Hilar Andikkadavath
Best Answer

You can replace ORM functions search(), search_read() with PSQL select query. You can also use insert into the query to create records but it is not promoted.

eg:


query = "...."
cr.execute(query, params
Avatar
Discard
Related Posts Replies Views Activity
ORM: Create a record with a psecific id Solved
create orm id
Avatar
Avatar
1
Jun 19
4266
creation/update: a mandatory field is not correctly set
create orm browse
Avatar
0
Mar 15
3686
creation/update: a mandatory field is not correctly set
create orm browse
Avatar
Avatar
1
Mar 15
8293
How can I speedup account.account creation? Solved
create orm api erppeek
Avatar
Avatar
4
Jan 17
6893
Modify ORM create method behavior two times using inheritance [Old API] [SOLVED] Solved
create orm method override
Avatar
Avatar
1
Nov 15
4780