Categories Sql Queries time > 100 s

Hello,

The categories queries take sometimes more that 1000 s to finish this is causing cpu charge 100% and server down.

 

Exemple from the slow query log:

 

# Query_time: 787  Lock_time: 0  Rows_sent: 9  Rows_examined: 19998
use com;
SELECT
`tgs`.`Category` as `Category`,
`tgs`.`Date` as `Date`,
COUNT(`tgs`.`ID`) AS `count`
FROM `sys_categories` `tgs` WHERE `tgs`.`Owner` != 0 AND `tgs`.`Category`  IN (SELECT `Category` FROM `sys_categories` WHERE `Type` = tgs.`Type` AND  `Owner` = 0) AND `tgs`.`Type` = 'bx_sites' AND tgs.`Status` = 'active' GROUP BY `Category`;

 

This need to be solved as soon as possible.

With all my respect.

Quote · 17 Oct 2010

your host?

ManOfTeal.COM a Proud UNA site, six years running strong!
Quote · 17 Oct 2010

 

your host?

 

A dedicated server:

Intel Xeon i7 W3520
4x 2x 2.66+ GHz
8 Mo L2 - QPI 4.8 GT/sec
Virtualisation: Instructions VT
Turbo Boost Technologie @ 2.93GHz

12 Go DDR3

200 Mbps
SLA Premium

Quote · 17 Oct 2010

We will check it

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 18 Oct 2010

we are already checking this problem...

Rules → http://www.boonex.com/terms
Quote · 18 Oct 2010

Ticket created: http://www.boonex.com/trac/dolphin/ticket/2232

Rules → http://www.boonex.com/terms
Quote · 18 Oct 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.