View Issue Details

IDProjectCategoryView StatusLast Update
0007276Talerexchangepublic2023-09-23 13:09
ReporterChristian Grothoff Assigned ToChristian Grothoff 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
PriorityurgentSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product Versiongit (master) 
Target Version0.9.3Fixed in Version0.9.3 
Summary0007276: improve wirewatch performance via multi-value insert
DescriptionRight now, we do a separate INSERT per wire transfer, which needs one RTT per request to the database.

We could likely significantly improve wirewatch performance if we batched these requests, providing multiple tuples of values for a single INSERT.
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2023-04-18 18:44

manager   ~0020120

Code exists in reserves_in_insert, but needs urgent correctness review!

Christian Grothoff

2023-04-22 13:17

manager   ~0020125

Bugs fixed (including unrelated ones in fakebank and wirewatch), performance on my desktop due to batching went up from 33k to 43k TPS when going from batch size 1 to 8.

Issue History

Date ModifiedUsernameFieldChange
2022-07-05 11:15Christian GrothoffNew Issue
2022-07-05 11:15Christian GrothoffStatusnew => assigned
2022-07-05 11:15Christian GrothoffAssigned To => Christian Grothoff
2022-11-08 14:13Christian GrothoffAssigned ToChristian Grothoff => user1649
2022-12-20 18:38Christian GrothoffTarget Version => 0.11
2023-04-13 19:56Christian GrothoffAssigned Touser1649 => Christian Grothoff
2023-04-18 18:44Christian GrothoffNote Added: 0020120
2023-04-18 18:45Christian GrothoffPrioritynormal => urgent
2023-04-18 18:45Christian GrothoffTarget Version0.11 => 0.9.3
2023-04-22 13:17Christian GrothoffStatusassigned => informing
2023-04-22 13:17Christian GrothoffResolutionopen => fixed
2023-04-22 13:17Christian GrothoffFixed in Version => 0.9.3
2023-04-22 13:17Christian GrothoffNote Added: 0020125
2023-09-23 13:09Christian GrothoffStatusinforming => closed