Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035990
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. PlatformminorN/A2017-05-15 10:232022-02-01 08:08
ReportercaristuView Statuspublic 
Assigned ToTriage Platform Base 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035990: 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
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0035989 acknowledgedTriage Platform Base Default session values calculation on login is slow having a big amount of organizations 

-  Notes
There are no notes attached to this issue.

- 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 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 View Revisions
2017-05-29 13:07 shuehner Issue Monitored: shuehner
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker