Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Add indices to PostgreSQL tables in custom module: Is overriding _auto_init and using _execute_sql the best way?
For a module I am writing, a new model based on a SQL view performs poorly unless I add some indices to the account_invoice, account_move_line and account_voucher tables in PostgreSQL.
What is the best way for my module to add these same indices?
I know how to do this via overriding _auto_init and using _execute_sql.
Is there another way? A better way?
I have used another way for creating indices on the columns which I want into particular model.
I have just inherit that columns of a particular model and put the "select=True" into column defination like below.
'product_id':fields.many2one('product.product', 'Product', select=True),
System will automatically made an index on the product_id column of inherited model.
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/9/14, 8:30 PM|
|Seen: 2422 times|
|Last updated: 3/16/15, 8:10 AM|