Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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)
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
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
