Project:
| View Revisions: Issue #44911 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0044911: Incremental refresh of Product cannot use index on updated | ||
| Revision | 2020-08-27 15:08 by AugustoMauch | ||
| Description | This is part of the query done to do an incremental refresh of products: hql += "AND ((product.$incrementalUpdateCriteria) OR (pli.$incrementalUpdateCriteria) OR (ppp.$incrementalUpdateCriteria) OR (product.uOM.$incrementalUpdateCriteria))"; This means that a product will be returned if any of these have been modified: - the product itself - its entry in the assortment - its entry in the price list - its unit of measure This is very complete, but it does not have good performance with big volumes, because the OR clauses prevents the use of indexes. An index should be added to m_product.updated |
||
| Revision | 2020-08-27 15:07 by AugustoMauch | ||
| Description | This is part of the query done to do an incremental refresh of products: hql += "AND ((product.$incrementalUpdateCriteria) OR (pli.$incrementalUpdateCriteria) OR (ppp.$incrementalUpdateCriteria) OR (product.uOM.$incrementalUpdateCriteria))"; This means that a product will be returned if any of these have been modified: - the product itself - its entry in the assortment - its entry in the price list - its unit of measure This is very complete, but it does not have good performance with big volumes, because the OR clauses prevents the use of indexes. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |