ppigazzini
ppigazzini
DEV updated. I found an old script able to bench the mongodb query.
@dav1312 I'm commuting now, not able to test code. I wonder if the correct count of the documents it's simply `len(runs_list)` with the master query and comprehension. EDIT_000: no, the...
Bench of the first proposed code (no indexes), master and PR are on par (`limit = 25` as used in `view.py`) ``` elapsed time: 0.2326268172264099 elapsed time: 0.22734872102737427 ``` ```python...
DEV with new indexes on `runs `collection. The bench of the new query with the indexes doesn't improve (elapsed time: 0.22787032127380372) The bench of the master query with the indexes...
> > The bench of the master query with the indexes is 200x slower! > > You mean the new indexes with master? This code is very slow with the...
DEV and indexes updated, here is the bench: ``` elapsed time: 0.20528266429901124 elapsed time: 0.20790423154830934 ``` The pagination on DEV is very slow.
> Can we speed up pagination making something like this? If the page_size is 25, search page_size + 1 elements (skipping if necessary) to see if there is a next...
I wait @vondele opinion before merging this.