[TYPO3-core] RFC: performance enhancement for tstemplate/cache_pagesection

Martin Kutschker Martin.Kutschker at n0spam-blackbox.net
Tue Aug 29 11:21:42 CEST 2006


Dmitry Dulepov schrieb:
> Hi!
> 
> /* I am starting to post performance enhancement patches :) */
> 
> This is SVN patch request.
> 
> Problem: database calls in the t3lib/class.t3lib_tstemplate.php are not 
> optimal and seriously impact mysql performance. There is a query that 
> deletes entry from cache_pagesection and second query reinserts the 
> entry with the same primary key. The problem is that this specific 
> delete query takes over 20 seconds on the InnoDb engine (default for 
> mysql>4.x) at peak hours on a server with lots of pages.

Shouldn't be too fast on Myisam as well.

> Solution: change DELETE/INSERT to UPDATE/INSERT_on_update_failure.

+1 (for trunk) but rename $insertFields to something else eg $dbFields or 
$pagesectionFields.

Masi



More information about the TYPO3-team-core mailing list