View Issue Details

IDProjectCategoryView StatusLast Update
0004947Talermerchant backendpublic2017-06-06 12:18
ReporterMarcello Stanisci Assigned ToMarcello Stanisci Resolution deadline
ImplementerReviewer 
Release signed byDeployed by 
VerifierCommunicator 
Data protection authority notification requiredNo  
CSIRT notification requiredNo  
Estimated effort (hours)Actual effort (hours)0 
Fast-trackNo
Work packagenone
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Versiongit (master) 
Target Version0.3Fixed in Version0.3 
Summary0004947: Optimize how DB skips rows upon /history.
DescriptionDB now uses a wasteful tecnique to skip the first N rows from the DB results
when it serves /history.

The tecnique shold be improved via using index-based searches, as privately
discussed.

See also:
http://use-the-index-luke.com/sql/partial-results/fetch-next-page
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Marcello Stanisci

2017-03-20 15:28

reporter   ~0011957

b8f25a0..b6f8454

Issue History

Date ModifiedUsernameFieldChange
2017-03-10 16:14Marcello StanisciNew Issue
2017-03-10 16:14Marcello StanisciStatusnew => assigned
2017-03-10 16:14Marcello StanisciAssigned To => Marcello Stanisci
2017-03-18 22:27Christian GrothoffProduct Version => git (master)
2017-03-18 22:27Christian GrothoffTarget Version => 0.5
2017-03-20 15:28Marcello StanisciStatusassigned => informing
2017-03-20 15:28Marcello StanisciResolutionopen => fixed
2017-03-20 15:28Marcello StanisciNote Added: 0011957
2017-03-29 14:44Christian GrothoffFixed in Version => 0.3
2017-03-29 14:44Christian GrothoffTarget Version0.5 => 0.3
2017-06-06 12:18Christian GrothoffStatusinforming => closed
2025-03-22 13:09Christian GrothoffCategorymechant backend => merchant backend