Bug #58357
closedEpic #55070: Workpackages
Epic #55065: WP: Overall System Performance (Backend and Frontend)
Superfluous SQL queries on copying records
100%
Description
Hello,
We encounter performance problems with TYPO3 6.1, especially visible during page copy. To understand the origin of the problem, we've installed a clean 6.1 (6.1.7) and 6.2 (6.2.1) TYPO3 version and check what's appended on MySQL requests.
For our check :
- 7 pages created on the root directory
- 10 tt_contents created in the 7th page (6 textpic + 4 html)
- copy the 7th page
- paste it after the 7th page
We've activated MySQL query log and looked for queries executed during paste :
- TYPO3 6.1 : 2567 SQL queries
- TYPO3 6.2 : 1827 SQL queries
The difference between 6.1 and 6.2 seems to be an optimization with backend caching (cf_* tables) where all the treatment is done once at the end with 6.2, sounds good !
However, there's still a lot of queries and we can see many queries which seems to be useless like "select ... where uid = 0". In our case, these queries concern page, sys_file_reference and tt_content tables. Ex :
SELECT editlock FROM pages WHERE uid=0
SELECT hidden FROM pages WHERE uid=0
SELECT title FROM pages WHERE uid=0
SELECT doktype FROM pages WHERE uid=0
SELECT TSconfig FROM pages WHERE uid=0
SELECT storage_pid FROM pages WHERE uid=0
SELECT is_siteroot FROM pages WHERE uid=0
SELECT php_tree_stop FROM pages WHERE uid=0
SELECT tx_impexp_origuid FROM pages WHERE uid=0
SELECT url FROM pages WHERE uid=0
SELECT starttime FROM pages WHERE uid=0
SELECT endtime FROM pages WHERE uid=0
SELECT urltype FROM pages WHERE uid=0
SELECT shortcut FROM pages WHERE uid=0
SELECT shortcut_mode FROM pages WHERE uid=0
SELECT no_cache FROM pages WHERE uid=0
SELECT fe_group FROM pages WHERE uid=0
SELECT subtitle FROM pages WHERE uid=0
SELECT layout FROM pages WHERE uid=0
SELECT url_scheme FROM pages WHERE uid=0
SELECT target FROM pages WHERE uid=0
SELECT media FROM pages WHERE uid=0
SELECT lastUpdated FROM pages WHERE uid=0
SELECT keywords FROM pages WHERE uid=0
SELECT cache_timeout FROM pages WHERE uid=0
SELECT cache_tags FROM pages WHERE uid=0
SELECT newUntil FROM pages WHERE uid=0
SELECT description FROM pages WHERE uid=0
SELECT no_search FROM pages WHERE uid=0
SELECT abstract FROM pages WHERE uid=0
SELECT module FROM pages WHERE uid=0
SELECT extendToSubpages FROM pages WHERE uid=0
SELECT author FROM pages WHERE uid=0
SELECT author_email FROM pages WHERE uid=0
SELECT nav_title FROM pages WHERE uid=0
SELECT nav_hide FROM pages WHERE uid=0
SELECT content_from_pid FROM pages WHERE uid=0
SELECT mount_pid FROM pages WHERE uid=0
SELECT mount_pid_ol FROM pages WHERE uid=0
SELECT alias FROM pages WHERE uid=0
SELECT l18n_cfg FROM pages WHERE uid=0
SELECT fe_login_mode FROM pages WHERE uid=0
SELECT backend_layout FROM pages WHERE uid=0
SELECT backend_layout_next_level FROM pages WHERE uid=0
SELECT categories FROM pages WHERE uid=0
We can count 801 queries with 6.1 and 820 with 6.2, so this problem (cause I suppose this is not "normal") is still not solved.
I join the both SQL log files for TYPO3 6.1 and 6.2 of all queries executed during "paste" action.
Files