[TYPO3-performance] Problem with Database queries

[Volker Lieder]

Hi Björn,

thank you, i will talk back to the customer.
Attached is a listing from slow query log.

Regards,
Volker Lieder

> Am 26.04.2011 13:18, schrieb Volker Lieder:
>> 2612970	kunde	www01.kunde.de:33624	customersdb	Query	239	Sending
>> data	SELECT COUNT(*) AS anzahl\nFROM   (SELECT  COUNT(*),\n
>>   v.`user_id`\n       FROM     view_customer_products_details6 v\n
>> WHERE    (v.`licenses`         LIKE '%0023 0000%'\n                )\n
>>     AND      v.`user_id` IN\n                (SELECT v.`user_id`\n
>>          FROM    view_customer_products_details6 v\n
>> WHERE   `licenses` LIKE '%000A 0004%'\n                )\n       GROUP
>> BY v.`user_id`\n       )\n       t1
>
> This one looks strange (and is not a typo3 query):
> 2612970	kunde	www01.kunde.de:33624	customersdb	Query	239	Sending data
> SELECT COUNT(*) AS anzahl\nFROM   (SELECT  COUNT(*),\n
> v.`user_id`\n       FROM     view_customer_products_details6 v\n
> WHERE    (v.`licenses`         LIKE '%0023 0000%'\n                )\n
>      AND      v.`user_id` IN\n                (SELECT v.`user_id`\n
>            FROM    view_customer_products_details6 v\n
> WHERE   `licenses` LIKE '%000A 0004%'\n                )\n       GROUP
> BY v.`user_id`\n       )\n       t1
>
> Does the slow-query log tell you anything?
> _______________________________________________
> TYPO3-performance mailing list
> TYPO3-performance at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-performance
>