excessive server CPU usage

221 Posts

When I've noticed the problem the website was not under the main domain so there ware very fiev people using it. Ive been using getResources previously to filter events on other website and never had this problem....
I will still look for solutions

Lucas from AroundCyprus.net

1,572 Posts

Paulp Reply #12, 13 years, 6 months ago

Personally i would limit what get resources is looping through, do you need it to query every TV on a resource ? if not try using &processTVs and &processTVList so that it's only looking at the ones needed and also do you need it to process the content on every resource ?

http://rtfm.modx.com/display/ADDON/getResources

221 Posts

lx Reply #13, 13 years, 6 months ago

Thanks Paul for giving me this idea.
I've added the selected TV that I actually need but unfortunately It didn't solve my problems.

Can this errors have to do something with it?

[2013-04-14 16:54:37] (ERROR in xPDOConnection::connect @ /........../tgd.website.pl/core/xpdo/xpdo.class.php : 3003) SQLSTATE[08004] [1040] Too many connections
[2013-04-14 16:54:37] (ERROR @ /index.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?  -

Lucas from AroundCyprus.net

221 Posts

lx Reply #14, 13 years, 6 months ago

I'm still struggling with the problem and don't know where to look else for solutions ....

Lucas from AroundCyprus.net