Issue 11695

Title
Set in a configuration the number of of row to prefetch
Priority
feature
Status
unread
Nosy list
ced, pokoli
Assigned to
Keywords

Created on 2022-09-09.18:49:51 by ced, last changed 3 weeks ago by pokoli.

Messages

Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-09-09.18:49:51

For now we prefetch IN_MAX rows (and make a second query if necessary).
But indeed this value may be too small as the cost of reading more data depend on the power/memory and speed between the server and the database.
Also this value should depend on the number of column prefetched. The more there are, the less must be prefetched.
Probably a default value of 10_000 / len(columns) should be better default.

History
Date User Action Args
2022-09-12 14:59:37pokolisetnosy: + pokoli
2022-09-09 18:49:51cedcreate

Showing 10 items. Show all history (warning: this could be VERY long)