Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035990Openbravo ERPA. Platformpublic2017-05-15 10:232022-02-01 08:08
Reportercaristu 
Assigned ToTriage Platform Base 
PriorityhighSeverityminorReproducibilityN/A
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035990: Sqlc calculates all records to retrieve later the first result
DescriptionSqlc 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 ReproduceIn description
Proposed Solution
Additional Information
TagsPerformance
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 ModifiedUsernameFieldChange
2017-05-15 10:23caristuNew Issue
2017-05-15 10:23caristuAssigned To => platform
2017-05-15 10:23caristuModules => Core
2017-05-15 10:23caristuTriggers an Emergency Pack => No
2017-05-15 10:23caristuRelationship addedrelated to 0035989
2017-05-15 11:10caristuTag Attached: Performance
2017-05-15 11:31caristuSummarySqlc calculates all registers to retrieve later the first result => Sqlc calculates all records to retrieve later the first result
2017-05-15 11:31caristuDescription Updatedbug_revision_view_page.php?rev_id=15167#r15167
2017-05-29 13:07shuehnerIssue Monitored: shuehner
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.