Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0021072 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Retail Modules] Web POS | minor | always | 2012-07-13 13:57 | 2015-01-20 14:25 | |||||||
| Reporter | iperdomo | View Status | public | |||||||||
| Assigned To | guilleaer | |||||||||||
| Priority | low | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | OpenJDK 1.6.0_24 | |||||||
| OS Version | 3.4.4-1-ARCH | Database version | 9.1.4 | Ant version | 1.8.2 | |||||||
| Product Version | SCM revision | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | No | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0021072: Order cache stores the serialized version of the product image, resulting in a waste of space | |||||||||||
| Description | When you add a ticket, on every ticket modification action, we're storing the ticket in a local client database. This ticket gets serialized in a JSON format. If you add images (thumbnails) to your products, the serialized version of the ticket contains the base64 version of the image; resulting in a waste of space. | |||||||||||
| Steps To Reproduce | * Disable the removal of the ticket after sending the ticket to the server (see OB.UTIL.processOrders) * Add an image to 1 product (in Openbravo) * Create a ticket using the product configured before * Check the resulting record in the database --- Some numbers: 1 order with 10 lines ~ 8KB 1 order with 10 lines (with image) ~ 64KB | |||||||||||
| Proposed Solution | Remove the image when serializing the ticket object before saving it in the client database | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  order.json [^] (12,900 bytes) 2012-07-14 12:14 | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0050575) iperdomo (viewer) 2012-07-14 12:14 |
We can improve the way we store the tickets. It's a JSON serialized version of the whole object, but it includes too much redundant information. 8KB for an order with 10 lines is too much. See the attached file (order.json) |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-07-13 13:57 | iperdomo | New Issue | |
| 2012-07-13 13:57 | iperdomo | Assigned To | => alostale |
| 2012-07-13 13:57 | iperdomo | OBNetwork customer | => No |
| 2012-07-13 14:01 | iperdomo | Assigned To | alostale => AugustoMauch |
| 2012-07-14 12:14 | iperdomo | Note Added: 0050575 | |
| 2012-07-14 12:14 | iperdomo | File Added: order.json | |
| 2012-12-20 17:55 | iciordia | Assigned To | AugustoMauch => guilleaer |
| 2013-02-06 10:42 | migueldejuana | Target Version | => RMP20 |
| 2013-02-28 08:13 | marvintm | Target Version | RMP20 => |
| 2013-08-08 03:48 | eintelau | Issue Monitored: eintelau | |
| 2015-01-20 14:25 | mtaal | Triggers an Emergency Pack | => No |
| 2015-01-20 14:25 | mtaal | Priority | urgent => low |
| 2015-01-20 14:25 | mtaal | Severity | major => minor |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |