Bug #22982
closed
tslib_cObj->getTreeList caching not able to handle really large trees
Added by form4 GmbH & Co. KG over 14 years ago.
Updated about 6 years ago.
Description
We have a really large tree and request all subpages of the root page to get a list of the lastUpdated pages. It is a plugin that appears on serveral pages.
This works correct for the first, uncached hit of a page, but a request of another page that contains plugin retuns a different result.
Debugging that issue shows, that on the first page approximate 13.000 page ids are relevant, but on another page only about 10.000 page ids.
It appears because the first hit is an uncached processing of the tslib_cObj->getTreeList and all page id are returned. The second request returns the cached treelist of table cache_treelist. Changing the type of the database field fixes this issue.
FIX: change field 'treelist' of table 'cache_treelist' to type LONGTEXT
(issue imported from #M14848)
- Status changed from New to Needs Feedback
- Target version deleted (
0)
- Is Regression set to No
Hi,
as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (4.5 or 6.1)?
The problem still exists , the type of the field 'treelist' of table 'cache_treelist' is still 'Text'.
We recommend to change it to type 'LONGTEXT'.
- Status changed from Needs Feedback to New
I would vote for mediumblob/mediumtext.
mediumtext
A TEXT column with a maximum length of 16,777,215 (224 – 1) characters. The effective maximum length is less
if the value contains multi-byte characters. Each MEDIUMTEXT value is stored using a 3-byte length prefix
that indicates the number of bytes in the value.
For longtext/longblob in the description we can read:
The effective maximum length of LONGTEXT columns also depends on the configured maximum packet size in the client/server protocol and available memory.
So there is a need of checking packet size, which we don't have.
- Category set to Caching
- Status changed from New to Accepted
- Priority changed from Should have to Could have
- Status changed from Accepted to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/36092
- Status changed from Under Review to New
- Status changed from New to Resolved
- % Done changed from 0 to 100
- Status changed from Resolved to Closed
Also available in: Atom
PDF