Project: 	
  | View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0035990 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] A. Platform | minor | N/A | 2017-05-15 10:23 | 2022-02-01 08:08 | |||||||
| Reporter | caristu | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| 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 | |||||||||||
| Tags | Performance | |||||||||||
| Attached Files | ||||||||||||
		  Relationships		[ Relation Graph ] 
		[ Dependency Graph ] 
			 | 
||||||||
  | 
||||||||
  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 | 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 |