Inefficient use of database
Posted: Thu Oct 26, 2006 11:08 am
My web hosts, 1&1, are saying that the CMS is taking up too many server resources because of 'inefficiency'; they sent me an email with the following:
I don't want to have to pay for a private server; is there any quick fix that can be performed to combat this?
Code: Select all
user count query_time lock_time rows_sent rows_examined
dbo177471083 116 1131[28](9.75) 424[21](3.66) 679[15](5.85)
104774[968](903.22)
dbo177471083 107 SELECT mn.*, mnc.news_category_name, mnc.long_name,
u.username, u.first_name, u.last_name FROM cms_module_new
s mn LEFT OUTER JOIN cms_module_news_categories mnc ON
mnc.news_category_id = %% LEFT OUTER JOIN cms_users u ON u.user_id = %%
WHERE status = %% AND (mnc.news_category_name = %% OR
mnc.news_category_name = %% OR mnc.news_category_name = %% OR mnc.news_
category_name = %%) AND ( IFNULL(start_time, %%) < %%) AND ((
IFNULL(end_time, %%) = %%) OR (end_time > %%)) LIMIT %%;
*** dbo177471083@infong216: 43120 Queries: 43120 Selects, 3936 Connects