TYPO3 Core

Why not cache "SELECT * FROM" on every table? scnr

Alexander Schnitzler wrote:

Why not cache "SELECT * FROM" on every table? scnr

Because it would - most likely - take up too much ram.

https://de.wikipedia.org/wiki/Liste_von_Abkürzungen_(Netzjargon)#S

Beware with "uid IN (1,2,3)"-query, there is a hard-limit to 1000 items in the list when using MySQL. This is why I implemented those kinds of queries many times like that:

        $chunkSize = 1000;
        $constraints = array();
        while (count($uids) > 0) {
            $chunk = array_slice($uids, 0, $chunkSize);
            if ($plainArray) {
                $constraints[] = 'uid IN (' . implode(',', $chunk) . ')';
            } else {
                $constraints[] = $query->in('uid', $chunk);
            }
            $uids = array_slice($uids, count($chunk));
        }

(was used in the context of doing complex queries to retrieve uids of objects to be returned in some findBy method the "old" way, efficiently, without Extbase, and only then use Extbase to fetch domain objects.

Of course with 10 or 100 posts, this is not a problem but we should think of real life scenarios as well!

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/32286

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/32286

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/32286

the pending patch was abandoned.