[TYPO3-core] RFC: performance enhancement for tstemplate/cache_pagesection
Martin.Kutschker at n0spam-blackbox.net
Tue Aug 29 11:21:42 CEST 2006
Dmitry Dulepov schrieb:
> /* 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
More information about the TYPO3-team-core