Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035990 | Openbravo ERP | A. Platform | public | 2017-05-15 10:23 | 2022-02-01 08:08 |
|
| Reporter | caristu | |
| Assigned To | Triage Platform Base | |
| Priority | high | Severity | minor | Reproducibility | N/A |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035990: Sqlc calculates all records to retrieve later the first result |
| Description | Sqlc methods that returns a String as result, currently are calculating all the values matching the query but eventually only the first record is returned.
It would be better from a performance point of view if the query launched by the Sqlc method directly returned just one record. |
| Steps To Reproduce | In description |
| Proposed Solution | |
| Additional Information | |
| Tags | Performance |
| Relationships | | related to | design defect | 0035989 | | acknowledged | Triage Platform Base | Default session values calculation on login is slow having a big amount of organizations |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-05-15 10:23 | caristu | New Issue | |
| 2017-05-15 10:23 | caristu | Assigned To | => platform |
| 2017-05-15 10:23 | caristu | OBNetwork customer | => No |
| 2017-05-15 10:23 | caristu | Modules | => Core |
| 2017-05-15 10:23 | caristu | Triggers an Emergency Pack | => No |
| 2017-05-15 10:23 | caristu | Relationship added | related to 0035989 |
| 2017-05-15 11:10 | caristu | Tag Attached: Performance | |
| 2017-05-15 11:31 | caristu | Summary | Sqlc calculates all registers to retrieve later the first result => Sqlc calculates all records to retrieve later the first result |
| 2017-05-15 11:31 | caristu | Description Updated | bug_revision_view_page.php?rev_id=15167#r15167 |
| 2017-05-29 13:07 | shuehner | Issue Monitored: shuehner | |
| 2022-02-01 08:08 | alostale | Assigned To | platform => Triage Platform Base |