Re: [TYPO3-english] Site Slowdown - MySQL Query - Possible TT-News Related Question

2011-07-15 Thread Jigal van Hemert
Hi, On 14-7-2011 21:11, Louis Coppola wrote: SELECT group_concat( cast(pid as char)) as pids FROM tt_content WHERE list_type=9 and hidden=0 Can anyone tell me what this query is doing, and what could be causing it to hang in this way? This query produces a comma separated list of page IDs

Re: [TYPO3-english] Site Slowdown - MySQL Query - Possible TT-News Related Question

2011-07-15 Thread Mathias Schreiber [wmdb]
Am 14.07.11 21:11, schrieb Louis Coppola: SELECT group_concat( cast(pid as char)) as pids FROM tt_content WHERE list_type=9 and hidden=0 Can anyone tell me what this query is doing, and what could be causing it to hang in this way? I am attempting to track and diagnose the problem further but

Re: [TYPO3-english] Site Slowdown - MySQL Query - Possible TT-News Related Question

2011-07-15 Thread Björn Pedersen
Am 15.07.2011 08:09, schrieb Jigal van Hemert: Hi, On 14-7-2011 21:11, Louis Coppola wrote: SELECT group_concat( cast(pid as char)) as pids FROM tt_content WHERE list_type=9 and hidden=0 Can anyone tell me what this query is doing, and what could be causing it to hang in this way?

Re: [TYPO3-english] Site Slowdown - MySQL Query - Possible TT-News Related Question

2011-07-14 Thread Christian Kuhn
Hey, On 07/14/2011 09:11 PM, Louis Coppola wrote: Is there anyway/extension that I can use to see which extension or function in my system is causing this query to be executed? you could try to use http://forge.typo3.org/projects/show/extension-mf_mysql_profiler . The extension xclasses