In a form, I have a many2one filed, refering to a table with +100k rows.
For some cases, the amount of result can be more than 10 or 20k.
Especially on sao, retrieving all the results can take minutes, preventing the user to continue typing an precising his query.
Is there a way to limit the results to the first 50 of 100 first records ?
Thank you for your help.