View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003643 | Taler | exchange | public | 2015-01-31 20:05 | 2015-03-22 16:17 |
| Reporter | Christian Grothoff | Assigned To | Christian Grothoff | Resolution deadline | |
| Implementer | Reviewer | ||||
| Release signed by | Deployed by | ||||
| Verifier | Communicator | ||||
| Data protection authority notification required | No | ||||
| CSIRT notification required | No | ||||
| Estimated effort (hours) | Actual effort (hours) | 0 | |||
| Fast-track | No | ||||
| Work package | none | ||||
| Priority | normal | Severity | feature | Reproducibility | N/A |
| Status | closed | Resolution | fixed | ||
| Platform | i7 | OS | Debian GNU/Linux | OS Version | squeeze |
| Product Version | git (master) | ||||
| Target Version | 0.0 | Fixed in Version | 0.0 | ||
| Summary | 0003643: refresh often loops over many rows in DB | ||||
| Description | During 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 Information | This 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. | ||||
| Tags | No tags attached. | ||||
| related to | 0003608 | closed | Christian Grothoff | need a clean database abstraction (API) and implementation thereof |
| child of | 0003644 | closed | Christian Grothoff | test DB backend using Postgres |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-01-31 20:05 | Christian Grothoff | New Issue | |
| 2015-01-31 20:06 | Christian Grothoff | Relationship added | related to 0003608 |
| 2015-01-31 20:07 | Christian Grothoff | Relationship added | child of 0003644 |
| 2015-03-22 13:26 | Christian Grothoff | Note Added: 0009032 | |
| 2015-03-22 13:26 | Christian Grothoff | Status | new => informing |
| 2015-03-22 13:26 | Christian Grothoff | Fixed in Version | => 0.0 |
| 2015-03-22 13:26 | Christian Grothoff | Resolution | open => fixed |
| 2015-03-22 13:26 | Christian Grothoff | Assigned To | => Christian Grothoff |
| 2015-03-22 13:26 | Christian Grothoff | Target Version | => 0.0 |
| 2015-03-22 16:17 | Christian Grothoff | Status | informing => closed |
| 2016-02-18 14:43 | Christian Grothoff | Category | mint => exchange |