Ancestors

Toot

Written by Nicolas Évrard on 2023-06-15 at 08:18

The refactoring of #tryton search on amount has landed in default.

It started from a somehow controversial idea to remove the search to the current implementation exploiting the new index feature from 6.6 and the idea that invoices are mostly in the posted state.

https://foss.heptapod.net/tryton/tryton/-/merge_requests/552

[#]usetheindexesluke

=> More informations about this toot | More toots from nicoe

Descendants

Written by Nicolas Évrard on 2023-06-15 at 08:54

And so I wonder how this level of performance can be reached with simpler index definition.

Because we're using partial indexes with the "INCLUDE" functionality from #postgres, nothing that could be defined by a parameter on a field definition.

Of course there is still the possibility to send directly SQL to the database but it's a bit against the idea of a framework, isn't it?

=> More informations about this toot | More toots from nicoe