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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009550
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformminorhave not tried2009-06-18 18:132009-06-22 07:08
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version2.40MP7
StatusclosedFix in branch2.40Fixed in SCM revision3a9e7a9859b1
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009550: Use the new ignoreValues features of sqlc to speed up filters with value '%'

DescriptionUse the new ignore values feature to speed up queries using '%' as filter value.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks feature request 0009549 closedshuehner Use the new ignoreValues features of sqlc to speed up filters with value '%' 

-  Notes
(0017464)
hgbot (developer)
2009-06-19 12:04

 Repository: erp/stable/2.40
Changeset: 3a9e7a9859b18e3e18bff006fefa2f671bfe7e9b
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 18 18:17:12 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/3a9e7a9859b18e3e18bff006fefa2f671bfe7e9b [^]

Fixed 9550: Use the new ignoreValue feature of Sqlc to speed up queries with value '%'

---
M src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_data.xsql
M src/org/openbravo/erpCommon/info/Account.java
M src/org/openbravo/erpCommon/info/AccountElementValue.java
M src/org/openbravo/erpCommon/info/AccountElementValue_data.xsql
M src/org/openbravo/erpCommon/info/Account_data.xsql
M src/org/openbravo/erpCommon/info/BusinessPartner.java
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
M src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
M src/org/openbravo/erpCommon/info/DebtPayment_data.xsql
M src/org/openbravo/erpCommon/info/ImageInfo_data.xsql
M src/org/openbravo/erpCommon/info/Invoice.java
M src/org/openbravo/erpCommon/info/InvoiceLine.java
M src/org/openbravo/erpCommon/info/InvoiceLine_data.xsql
M src/org/openbravo/erpCommon/info/Invoice_data.xsql
M src/org/openbravo/erpCommon/info/Locator_data.xsql
M src/org/openbravo/erpCommon/info/ProductComplete.java
M src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
M src/org/openbravo/erpCommon/info/ProductMultiple_data.xsql
M src/org/openbravo/erpCommon/info/Product_data.xsql
M src/org/openbravo/erpCommon/info/Project_data.xsql
M src/org/openbravo/erpCommon/info/SalesOrder.java
M src/org/openbravo/erpCommon/info/SalesOrderLine.java
M src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
M src/org/openbravo/erpCommon/info/SalesOrder_data.xsql
M src/org/openbravo/erpCommon/info/ShipmentReceiptLine_data.xsql
M src/org/openbravo/erpCommon/info/ShipmentReceipt_data.xsql
---
(0017495)
sureshbabu (viewer)
2009-06-22 07:08

 Tested working fine

- Issue History
Date Modified Username Field Change
2009-06-18 18:14 shuehner Type feature request => backport
2009-06-18 18:14 shuehner fix_in_branch => 2.40
2009-06-19 12:04 hgbot Checkin
2009-06-19 12:04 hgbot Note Added: 0017464
2009-06-19 12:04 hgbot Status scheduled => resolved
2009-06-19 12:04 hgbot Resolution open => fixed
2009-06-19 12:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/3a9e7a9859b18e3e18bff006fefa2f671bfe7e9b [^]
2009-06-22 07:08 sureshbabu Status resolved => closed
2009-06-22 07:08 sureshbabu Note Added: 0017495
2009-06-22 07:08 sureshbabu Fixed in Version => 2.40MP7

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker