This hurts performance with default catalog indexes.

to enable cache for anonymous, login should not be included in HTML itself based on the cookie value. it should be the browser's job.

New SQLBase._getMessageList method has a very simple ZSQLCatalog-like API,
and replaces SQL{Dict,Queue}_readMessageList DTML scripts.

'include_processing' parameter disappears (in favor of 'processing')
and default behaviour is to include messages being processed.

Also clean-up the comments.

test for now was passing thanks to a lucky good ordering in indexation

Revert both revert, as the original commits were just raising another bug but was not the cause of this bug

This reverts commit e89d10aa.
This reverts commit ff1ca703.

add work around for the performance regression introduced in Zope 2.12.23 in BTreeFolder2, for the case where we use BTreeFolder2 directly.

readd work around for the performance regression introduced in Zope 2.12.23 in HBTreeFolder2, for the case where we use HBTreeFolder2 directly.

This reverts commit 3742a4c8.

This reverts commit dccbb3b8.

Take into account the fact that Base_getSectionUidListForSectionCategory returns -1 when no organisation exsits

Base_getSectionUidListForSectionCategory : returns [-1] if no organisations are member of this section_category.

This way we can directly pass the returned value as section_uid= to
getInventory without worrying about the problem that if this section category
has no member, then section_uid parameter is ignored.

use Base_getSectionUidListForSectionCategory instead of hack in where
expression which won't work if we don't have catalog as section selected

Sometime dialog fields are not validated ...

Use OOBTree instead of PersistentMapping. Because it is more disk-efficent,
it will reduce the number of conflicts, improve the performance.