Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0024694 | Openbravo ERP | A. Platform | public | 2013-09-04 17:57 | 2013-09-17 19:02 |
| Reporter | egoitz | ||||
| Assigned To | shankarb | ||||
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | 3.0MP27 | |||
| Merge Request Status | |||||
| Review Assigned To | AugustoMauch | ||||
| OBNetwork customer | OBPS | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0024694: After adding product characteristics to core the product simple selector has bad performance. | ||||
| Description | A now join has been included on the productsimple selector. left join p.genericProduct gp This makes the query slow with big amount of data | ||||
| Steps To Reproduce | On a product with thousendof products with arrond 30 price lists the selector takes 2 seconds to show data. | ||||
| Proposed Solution | Create the following index CREATE INDEX m_product_gen__prod ON m_product USING btree (Generic_Product_ID COLLATE pg_catalog."default" ); analyze m_product; | ||||
| Additional Information | |||||
| Tags | Performance | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2013-09-04 17:57 | egoitz | New Issue | |||
| 2013-09-04 17:57 | egoitz | Assigned To | => AugustoMauch | ||
| 2013-09-04 17:57 | egoitz | Modules | => Core | ||
| 2013-09-04 17:57 | egoitz | OBNetwork customer | => Yes | ||
| 2013-09-04 17:57 | egoitz | Triggers an Emergency Pack | => No | ||
| 2013-09-04 17:57 | egoitz | Tag Attached: Performance | |||
| 2013-09-05 08:41 | shankarb | Assigned To | AugustoMauch => shankarb | ||
| 2013-09-05 08:58 | shankarb | Review Assigned To | => AugustoMauch | ||
| 2013-09-05 08:58 | shankarb | Issue Monitored: AugustoMauch | |||
| 2013-09-05 09:00 | hgbot | Checkin | |||
| 2013-09-05 09:00 | hgbot | Note Added: 0060925 | |||
| 2013-09-05 09:00 | hgbot | Status | new => resolved | ||
| 2013-09-05 09:00 | hgbot | Resolution | open => fixed | ||
| 2013-09-05 09:00 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e22dd1199630733aa54d13e028c028070bb07479 [^] | ||
| 2013-09-10 17:37 | AugustoMauch | Note Added: 0061056 | |||
| 2013-09-10 17:37 | AugustoMauch | Status | resolved => closed | ||
| 2013-09-10 17:37 | AugustoMauch | Fixed in Version | => 3.0MP27 | ||
| 2013-09-17 19:02 | hudsonbot | Checkin | |||
| 2013-09-17 19:02 | hudsonbot | Note Added: 0061219 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||