[TYPO3-dev] TCEforms suggest fails on large sites
Steffen Gebert
steffen at steffen-gebert.de
Sat Sep 12 02:08:41 CEST 2009
Hi,
TCEforms is a really nice feature and I had some tests today.
Unfortunately it has hardcoded limits, which are too low for one of our
sites (>20.000 pages).
We have ~450 pages called "Links" or "Home" (each user has this page in
his default site).
So depending on how old/new a user is, these pages are found or not.
Because:
* queryTable() gets 50 (hardcoded) results from DB (every page in result
is called "Links")
* checkRecordAccess sorts all/most of them out
* count($rows) < $this->maxItems && $allRowsCount >= 50 &&
$recursionCounter < $this->maxItems
matches ($this->maxItems = 10)
* ++$recursionCounter and recursive call to get more results (start again)
So there is a maximum of 10 recursions (as recursionCounter < maxItems),
which I don't understand (has nothing to do with each other) and also
limits to (theretically) 500 examined records.
I don't know why, but the query doesn't find as much as expected: If I
increase maxItems to 50, pages are also not found. If I encrease to 200,
the maximum nesting level of 100 gets reached.
Wouldn't it make sense, to check as a limit for $allRowsCount > 50 *
$this->maxItems ? Nevertheless, this might also lead to reach maximum
nesting level :(
Only way to get it, was to change hardcoded LIMIT of 50 to way higher
values.
Hope you catch my thoughts.. it might sound a bit oversized to speak of
500 pages with the same name having only access to one of them.. but how
should I tell newer users that this great feature might not always work
for them :(
Hope you have ideas...
Regards
Steffen
More information about the TYPO3-dev
mailing list