[TYPO3-dev] Use of subqueries

Martin Kutschker masi-no at spam-typo3.org
Tue Oct 13 23:00:46 CEST 2009


Christian Kuhn schrieb:
> 
> Furthermore the FE admin panel is your friend. You could locate really
> slow extensions and look for long running queries. Take a special look
> to USER_INT queries. Always run queries on "real" data, if your tables
> are not big enough mysql might decide to not use any index at all.

Right. And after doing a mass import/delete you could run ANALYZE TABLE.

Masi




More information about the TYPO3-dev mailing list