View Issue Details

IDProjectCategoryView StatusLast Update
0003643Talerexchangepublic2015-03-22 17:17
ReporterChristian Grothoff Assigned ToChristian Grothoff  
PrioritynormalSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product Versiongit (master) 
Target Version0.0Fixed in Version0.0 
Summary0003643: refresh often loops over many rows in DB
DescriptionDuring refresh operations, we essentially are dealing with a 2d array. Currently, the DB API exposes the nature of this array (and the associated 1d arrays) fully to the database. While this is _clean_, it may be bad for _performance_ as it increase the number of queries we issue dramatically. We should thus consider combining the individual values along one (or even both) dimensions into one big value -- at least if all/most queries always access all values in linear sequence anyway. That way, we could reduce the IPC and number of DB searches significantly, possibly dramatically reducing the cost of refresh operations.
Additional InformationThis is an internal implementation detail of the database and should not affect the public mint API at all. However, it may affect the API between the main mint and the DB backend, and thus we should investigate this before finalizing the DB abstraction API.
TagsNo tags attached.

Relationships

related to 0003608 closedChristian Grothoff need a clean database abstraction (API) and implementation thereof 
child of 0003644 closedChristian Grothoff test DB backend using Postgres 

Activities

Christian Grothoff

2015-03-22 14:26

manager   ~0009032

Done as of 3a94a76..81e234e

Issue History

Date Modified Username Field Change
2015-01-31 21:05 Christian Grothoff New Issue
2015-01-31 21:06 Christian Grothoff Relationship added related to 0003608
2015-01-31 21:07 Christian Grothoff Relationship added child of 0003644
2015-03-22 14:26 Christian Grothoff Note Added: 0009032
2015-03-22 14:26 Christian Grothoff Status new => resolved
2015-03-22 14:26 Christian Grothoff Fixed in Version => 0.0
2015-03-22 14:26 Christian Grothoff Resolution open => fixed
2015-03-22 14:26 Christian Grothoff Assigned To => Christian Grothoff
2015-03-22 14:26 Christian Grothoff Target Version => 0.0
2015-03-22 17:17 Christian Grothoff Status resolved => closed
2016-02-18 15:43 Christian Grothoff Category mint => exchange