Re: [tryton-dev] Slow queries when searching m2m fields in big databases

2015-06-04 Thread Albert Cervera i Areny
2015-06-04 19:11 GMT+02:00 Jordi Esteve : > I'm analysing postgres performance in a big database (aprox. 1-2 million or > records of account.invoice.line and stock.move) and I have figured out that > slow queries are executed to get data related to m2m fields (I suppose the > same happens for o2m f

[tryton-dev] Slow queries when searching m2m fields in big databases

2015-06-04 Thread Jordi Esteve
I'm analysing postgres performance in a big database (aprox. 1-2 million or records of account.invoice.line and stock.move) and I have figured out that slow queries are executed to get data related to m2m fields (I suppose the same happens for o2m fields). I think the problem is how the search_