Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Is adding Indexes to core fields using modules a good idea?

postgresql index override

1 Vastaa

10743 Näkymät

edi

We are going to add some indexes to certain fields (Odoo 10). But I'm not 100% sure that this is the best approach. So currently I'm inheriting for example sale.order.line to add an index to product_id. Any side effect to this? If I uninstall the module it will not remove the field (that's good) but the index will stay.

class SaleOrderLine(models.Model):
    _inherit = 'sale.order.line'

    product_id = fields.Many2one('product.product', string='Product', domain=[('sale_ok', '=', True)], change_default=True, ondelete='restrict', required=True, index=True)

James Becker

I would love to know the answer to this question. I, too, am considering adding an index to a core field.

Răzvan Anastasescu

nobody answered until now on this ? I don't understand why Odoo didn't add indexes on a lot of ID fields as well, so I want to do this at least for a couple of them ...

Walid Redwan

Paras vastaus

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without having to search every row in a database table every time said table is accessed. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.

Indexes are a common way to enhance database performance. An index allows the database server to find and retrieve specific rows much faster than it could do without an index. But indexes also add overhead to the database system as a whole, so they should be used sensibly.

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Add indices to PostgreSQL tables in custom module: Is overriding _auto_init and using _execute_sql the best way? postgresql index v7	1 maalisk. 15	9064
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 helmik. 25	2867
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 tammik. 25	10026
Odoo backend to Google Data Studio Ratkaistu postgresql	2 tammik. 24	10139
Reason why Odoo being slow when there is huge data inside the database postgresql	7 tammik. 24	50864

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!