No Cache:
  13R: 46635.932 +/- 310.994 (min=46014.113, max=47618.809)
  1R: 3578.318 +/- 2879.959 (min=197.390, max=11038.699)
ERP5 Generic Cache:
  13R: 183.267 +/- 24.720 (min=163.087, max=303.120)
  1R: 28.588 +/- 11.183 (min=18.977, max=76.923)
Yoshida's Inventory Cache:
  13R: 102.679 +/- 8.349 (min=96.516, max=166.872)
  1R: 16.384 +/- 3.301 (min=10.767, max=27.993)
Yoshida's Inventory Cache using catalog.indexation_timestamp instead of stock.date:
  13R: 138.370 +/- 9.424 (min=132.227, max=187.422)
  1R: 47.519 +/- 7.743 (min=23.233, max=68.214)

New SQL INDEXES:
  ALTER TABLE stock ADD KEY `resource_section_node_date` (`resource_uid`, `section_uid`, `node_uid`, `date`);
  ALTER TABLE stock ADD KEY `variation_text_section_node` (`variation_text`, `section_uid`, `node_uid`);

This is not a new feature, this behavior is compatible with the old caching
implementation that was using inventory_stock table.
In other words, this brings backs the backword compatibility in invetory
caching.

We were joining catalog for section, node and resource, mainly in order to
expose _title and _relative_url in brains. We just need to select the
corresponding uids and let brains do another catalog search to get the object
when accessed.
Note that erp5_banking_core is not updated

Create a sql cache for getInventory call
Remove full-inventory optimisation as it now useless
Implement full-inventory feature directly into stock
Make erp5_pdm depends on this optimisation
Install optimisation for all unit tests

Also, movement with 0 price where ignored by omit_asset_increase /
omit_asset_decrease
Signed-off-by: Aurélien Calonne <aurel@nexedi.com>

To migrate, run:
alter table stock add column payment_request_uid bigint unsigned after funding_uid, add index payment_request_uid (payment_request_uid);
alter table inventory_stock add column payment_request_uid bigint unsigned after funding_uid;

Useful to check that 'portal_simulations' is properly migrated.

Fall back to implicit joins in this case.

We'd have to implement the collapsing of inner-joins contained inside other
inner-joins based on similar aliases, and consolidate their join conditions, before
allowing table aliases with explicit joins.

This commit reverts:
 631cab2b
 93cf49e4

Checked following occurrences in comments:
- "Python 2.[456]"
- "Zope 2.[891]"
- "BBB"
- "BACK"

Checked uses of:
- email, hashlib, numpy & tarfile (modules)
- ImportError
- string.Template
- suppress_events (parameter of _setObject)

Excluded:
- some forked modules (MailTemplates, PortalTransforms...)
- some i18n compatibility code

(requires to add an is_accountable column in stock table
and add some <dtml-if only_accountable> AND stock.is_accountable </dtml-if> in
Resource_zGet* skins)



git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@45758 20353a03-c40f-0410-a6d1-a30d3c3de9de

The only real issue was that ActivityTool was deriving from
BaseTool, this having isIndexable = True, and not being a
portal type (a.k.a no isResourceType kind of methods) and
raising errors when indexed.
Now, ActivityTool has a portal type, and such issues are gone.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@43198 20353a03-c40f-0410-a6d1-a30d3c3de9de

(This is a quickfix to get test results, the BaseTool.isIndexable
value will be investigated cleanly/thoroughly later)


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@43167 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/catalog_join@42598 20353a03-c40f-0410-a6d1-a30d3c3de9de

inventory queries by funding


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@39697 20353a03-c40f-0410-a6d1-a30d3c3de9de

have similar meaning than omit_input and omit_input, but are not based of the
inventory increase, but the asset value increase.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37346 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37333 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37332 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37292 20353a03-c40f-0410-a6d1-a30d3c3de9de

uid of this axis on the brain.
This means that if we do group_by_section_category=True, the brains will have
an attribute section_category_uid that will be the uid of the section category
for this brain.
Also add support for select_dict and select_list to have the same feature when
grouping on a related key.
Fix typo from r37215, group_by_project_category was not working


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37257 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37215 20353a03-c40f-0410-a6d1-a30d3c3de9de

Conflicts:
	bt5/erp5_base/bt/revision
	bt5/erp5_simulation/DocumentTemplateItem/InvoiceSimulationRule.py
	bt5/erp5_simulation/bt/revision
	bt5/erp5_trade/SkinTemplateItem/portal_skins/erp5_trade/Base_viewTradeFieldLibrary.xml
	bt5/erp5_trade/bt/change_log
	bt5/erp5_trade/bt/revision
	products/ERP5/Document/BusinessPath.py
	products/ERP5/Document/SimulationMovement.py
	products/ERP5/Document/TradeCondition.py
	products/ERP5/Document/TradeModelLine.py
	products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision
	products/ERP5Type/ERP5Type.py

git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/amount_generator@37129 20353a03-c40f-0410-a6d1-a30d3c3de9de

Fifo, Filo, WeightedAverage, MonthlyWeightedAverage and MovingAverage methods
are available


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@36624 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@36269 20353a03-c40f-0410-a6d1-a30d3c3de9de

If group_by= is passed, default group by parameters will not be applied.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@36232 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@34172 20353a03-c40f-0410-a6d1-a30d3c3de9de

Work in progress: transformations are not yet properly indexed,
tests are not written. this commit is just to share in advance a common API


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@33211 20353a03-c40f-0410-a6d1-a30d3c3de9de

queries. Default metric type is used instead


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@32160 20353a03-c40f-0410-a6d1-a30d3c3de9de

Use Shared.DC.ZRDB.Results.Results.r objects instead, which behave like the
tuples that Shared.DC.ZRDB.Results.Results want.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@32001 20353a03-c40f-0410-a6d1-a30d3c3de9de