What approach would be better performance-wise?

- Table A with serialized array of items in a Text field?
- Table A and Table B which would contain the items related to table A

The items will be used in many various searches and statistics.
I think the second approach is better?

Added 3 days later:

craziness : /

Added 6 days later:

how / what is the best way to use those cahce options, because like i said i have access to a few of them i just know how to setup them up with cotonti

The recent items and news are holding up the rest of the page from loading it seems like, is there a way to load them using ajax or some other way so the rest of the page will load on time?

Do you have caching turned on for the recent items plugin?

Should be at:

admin.php?m=config&n=edit&o=plug&p=recentitems

Added 11 hours later:

Here is what I got running the debug mode on with maintenance mode on:

Dev-mode :

SQL query	Duration	Timeline	Execution stack
(file[line]: function)	Query
BEGIN	0.000 ms	 
#3  	0.608 ms	9.640 ms	index.php [37]: require_once();
→ common.php [325]: CotDB->query();	SELECT * FROM sed_users WHERE user_id = 243
#4  	0.678 ms	10.590 ms	index.php [37]: require_once();
→ common.php [382]: CotDB->update();	UPDATE `sed_users` SET `user_lastlog`=1390974578 WHERE user_id=243
#5  	0.201 ms	12.176 ms	index.php [37]: require_once();
→ common.php [452]: include();
→ i18n.input.php [24]: MySQL_cache->get();
→ cache.php [727]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'i18n' AND c_name = 'locales'
#6  	0.497 ms	14.077 ms	index.php [37]: require_once();
→ common.php [452]: include();
→ whosonline.input.php [24]: CotDB->query();	SELECT * FROM sed_online WHERE online_userid=243
#7  	0.285 ms	14.661 ms	index.php [37]: require_once();
→ common.php [452]: include();
→ whosonline.input.php [69]: CotDB->delete();	DELETE FROM `sed_online` WHERE online_lastseen < 1390972778
#8  	0.475 ms	15.035 ms	index.php [37]: require_once();
→ common.php [452]: include();
→ whosonline.input.php [71]: CotDB->query();	SELECT COUNT(*) FROM sed_online WHERE online_name='v'
#9  	0.232 ms	15.590 ms	index.php [37]: require_once();
→ common.php [452]: include();
→ whosonline.input.php [72]: CotDB->query();	SELECT DISTINCT o.online_name, o.online_userid FROM sed_online o WHERE o.online_name != 'v' ORDER BY online_name ASC
#10  	0.361 ms	16.631 ms	index.php [37]: require_once();
→ common.php [461]: CotDB->query();	SELECT grp_maintenance FROM sed_groups WHERE grp_id='5'
#11  	3.878 ms	19.862 ms	index.php [37]: require_once();
→ common.php [626]: include();
→ hits.global.php [36]: cot_stat_inc();
→ hits.functions.php [56]: CotDB->query();	UPDATE sed_stats SET stat_value=stat_value+1 WHERE stat_name='totalpages'
#12  	0.384 ms	23.855 ms	index.php [37]: require_once();
→ common.php [626]: include();
→ hits.global.php [37]: cot_stat_update();
→ hits.functions.php [71]: CotDB->query();	INSERT INTO sed_stats (stat_name, stat_value) VALUES ('2014-01-29', 1) ON DUPLICATE KEY UPDATE stat_value=stat_value+1
#13  	0.509 ms	24.672 ms	index.php [37]: require_once();
→ common.php [626]: include();
→ banlist.global.php [25]: CotDB->query();	SELECT banlist_id, banlist_ip, banlist_reason, banlist_expire FROM sed_banlist WHERE banlist_ip IN ('67.248.100.12','67.248.100.*','67.248.*.*','67.*.*.*')
#14  	0.316 ms	32.574 ms	index.php [37]: require_once();
→ common.php [626]: include();
→ i18n.global.php [21]: MySQL_cache->get();
→ cache.php [727]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'i18n' AND c_name = 'structure'
#15  	0.827 ms	33.000 ms	index.php [37]: require_once();
→ common.php [626]: include();
→ i18n.global.php [25]: cot_i18n_load_structure();
→ i18n.functions.php [170]: CotDB->query();	SELECT * FROM sed_i18n_structure
#16  	0.435 ms	39.933 ms	index.php [126]: require_once();
→ index.php [46]: require_once();
→ header.php [86]: include();
→ hits.header.php [30]: CotDB->query();	SELECT stat_value FROM sed_stats where stat_name='maxusers' LIMIT 1
#17  	0.286 ms	40.939 ms	index.php [126]: require_once();
→ index.php [46]: require_once();
→ header.php [86]: include();
→ page.header.php [23]: CotDB->query();	SELECT COUNT(*) FROM sed_pages WHERE page_state=1
#18  	0.167 ms	41.521 ms	index.php [126]: require_once();
→ index.php [46]: require_once();
→ header.php [86]: include();
→ page.header.php [46]: CotDB->query();	SELECT COUNT(*) FROM sed_pages WHERE page_state=2 AND page_ownerid = 243
#19  	0.329 ms	42.593 ms	index.php [126]: require_once();
→ index.php [46]: require_once();
→ header.php [86]: include();
→ contact.header.php [24]: CotDB->query();	SELECT COUNT(*) FROM sed_contact WHERE contact_val=0
#20  	7.739 ms	55.307 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ tags.index.php [25]: cot_tag_cloud();
→ tags.functions.php [95]: CotDB->query();	SELECT `tag`, COUNT(*) AS `cnt` FROM sed_tag_references WHERE tag_area = 'pages' GROUP BY `tag` ORDER BY RAND()
#21  	1.023 ms	70.180 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [108]: CotDB->query();	SELECT COUNT(*) FROM sed_com WHERE com_code='chat'
#22  	2.158 ms	71.300 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [110]: CotDB->query();	SELECT c.*, u.* FROM sed_com AS c LEFT JOIN sed_users AS u ON u.user_id = c.com_authorid WHERE com_area='chat' AND com_code='chat' ORDER BY com_id DESC LIMIT 0, 10
#23  	2.009 ms	74.258 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [119]: cot_parse();
→ functions.php [4133]: include();
→ bbcode.parser.php [19]: require_once();
→ bbcode.functions.php [16]: cot_bbcode_load();
→ bbcode.functions.php [155]: CotDB->query();	SELECT * FROM sed_bbcode WHERE bbc_enabled = 1 ORDER BY bbc_priority
#24  	1.408 ms	83.836 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#25  	1.585 ms	85.390 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#26  	0.219 ms	92.557 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#27  	0.327 ms	92.906 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#28  	0.413 ms	100.227 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#29  	0.320 ms	100.754 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#30  	0.197 ms	106.429 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#31  	0.292 ms	106.784 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#32  	0.286 ms	112.988 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#33  	0.241 ms	113.423 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#34  	0.490 ms	121.011 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#35  	0.541 ms	121.617 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ minichat.php [168]: minichat_build();
→ minichat.php [126]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#36  	0.364 ms	136.078 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [30]: CotDB->query();	SELECT * FROM sed_polls WHERE poll_type='index' AND poll_state='0' ORDER by poll_creationdate DESC LIMIT 2
#37  	0.172 ms	136.608 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [38]: cot_poll_form();
→ polls.functions.php [323]: CotDB->query();	SELECT pv_id FROM sed_polls_voters WHERE pv_pollid = 131 AND pv_userid = '243' LIMIT 1
#38  	0.247 ms	137.511 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [38]: cot_poll_form();
→ polls.functions.php [338]: CotDB->query();	SELECT SUM(po_count) FROM sed_polls_options WHERE po_pollid = 131
#39  	0.302 ms	137.844 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [38]: cot_poll_form();
→ polls.functions.php [341]: CotDB->query();	SELECT po_id, po_text, po_count FROM sed_polls_options WHERE po_pollid = 131 ORDER by po_id ASC
#40  	0.288 ms	144.651 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [49]: include();
→ comments.polls.index.tags.php [24]: cot_comments_link();
→ comments.functions.php [386]: cot_comments_count();
→ comments.functions.php [63]: CotDB->query();	SELECT COUNT(*) FROM sed_com WHERE com_area = ? AND com_code = ?
#41  	0.253 ms	146.212 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [38]: cot_poll_form();
→ polls.functions.php [323]: CotDB->query();	SELECT pv_id FROM sed_polls_voters WHERE pv_pollid = 129 AND pv_userid = '243' LIMIT 1
#42  	0.225 ms	147.166 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [38]: cot_poll_form();
→ polls.functions.php [338]: CotDB->query();	SELECT SUM(po_count) FROM sed_polls_options WHERE po_pollid = 129
#43  	0.311 ms	147.477 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [38]: cot_poll_form();
→ polls.functions.php [341]: CotDB->query();	SELECT po_id, po_text, po_count FROM sed_polls_options WHERE po_pollid = 129 ORDER by po_id ASC
#44  	0.236 ms	154.413 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ polls.index.php [49]: include();
→ comments.polls.index.tags.php [24]: cot_comments_link();
→ comments.functions.php [386]: cot_comments_count();
→ comments.functions.php [63]: CotDB->query();	SELECT COUNT(*) FROM sed_com WHERE com_area = ? AND com_code = ?
#45  	0.171 ms	158.588 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [32]: CotDB->query();	SELECT COUNT(DISTINCT com_code) FROM sed_com
#46  	0.266 ms	159.571 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [45]: CotDB->query();	SELECT MAX(com_id) AS _id, MAX(com_date) AS _date FROM sed_com GROUP BY com_code ORDER BY _date DESC LIMIT 0, 10
#47  	0.310 ms	159.915 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [53]: CotDB->query();	SELECT * FROM sed_com WHERE com_id IN('122516','122515','122514','122509','122507','122504','122503','122494','122493','122484') ORDER BY com_date DESC
#48  	0.525 ms	160.309 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 3498 LIMIT 1
#49  	0.745 ms	162.577 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 1613 LIMIT 1
#50  	0.500 ms	169.023 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 3497 LIMIT 1
#51  	1.847 ms	174.096 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 3219 LIMIT 1
#52  	1.542 ms	177.983 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 1582 LIMIT 1
#53  	0.514 ms	181.512 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 3232 LIMIT 1
#54  	1.176 ms	185.780 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 1032 LIMIT 1
#55  	1.231 ms	188.865 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 3422 LIMIT 1
#56  	1.943 ms	191.652 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentcomments.index.php [67]: CotDB->query();	SELECT * FROM sed_pages WHERE page_id = 3260 LIMIT 1
#57  	216.203 ms	199.715 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ news.php [96]: CotDB->query();	SELECT p.*, u.* , (SELECT COUNT(*) FROM `sed_com` WHERE com_area = 'page' AND com_code = p.page_id) AS com_count FROM sed_pages AS p LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid WHERE page_state = 0 AND page_cat <> 'system' AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat IN ('news','events','videos','competitions','gom-news','street-legal-download-news','real-world-news','game-news') ORDER BY page_date DESC LIMIT 0, 3
#58  	9.406 ms	416.061 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ news.php [98]: CotDB->query();	SELECT COUNT(*) FROM sed_pages AS p WHERE page_state = 0 AND page_cat <> 'system' AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat IN ('news','events','videos','competitions','gom-news','street-legal-download-news','real-world-news','game-news')
#59  	0.341 ms	431.157 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ news.php [142]: include();
→ tags.news.php [45]: cot_tag_list();
→ tags.functions.php [220]: CotDB->query();	SELECT `tag`, `tag_item` FROM sed_tag_references WHERE tag_item IN(3498,3496,3494) AND tag_area = 'pages'
#60  	979.040 ms	467.845 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [256]: CotDB->query();	SELECT p.*, u.* , (SELECT COUNT(*) FROM `sed_com` WHERE com_area = 'page' AND com_code = p.page_id) AS com_count FROM sed_pages AS p LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid WHERE page_state=0 AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat <> 'system' AND page_cat IN ('tutorials','3d-tutorials','street-legal-modding','photoshop-tutorials','articles','legal','downloads','street-legal-racing-redline','body-mods','car-mods','decal-mods','engine-mods','exhaust-mods','interior-mods','miscellanious-part-mods','rims-tires-wheel-mods','sound-mods','suspension-mods','texture-mods','the-games','tracks','tools','patches','paint-jobs','street-legal-1','sl1-body-parts','sl1-car-mods','sl1-decal-mods','sl1-engine-mods','sl1-exhaust-mods','sl1-interior-mods','sl1-misc-mods','sl1-rims-tires-mods','sl1-sound-mods','sl1-suspension','sl1-textures','sl1-game','dlsl1tools','sl1-patches','sl1-paint-jobs','cross-racing-championship','crc-car-mods','dlcrcskins','dlcrctracks','dlcrcgmodes','dlcrcmisc','dlgom','dlgomwallpaper','dlgomvideos','dlgommisc','dlgommusic','lfs','lfsskins','lfssetups','lfstools','dl_misc','dl_iv','dl_ivcars','dl_ivpatch','dl_ivsave','dl_ivskins','dl_ivother','dl_ivtools','dl_ivcheats','dl_ivvideo','dl_ivweapon','ferrari','ferraricar','ferraritrack','ferrarimisc','dlmax','dlmaxmodeld','dlmaxscripts','dlmaxplug-in','dlmaxtextures','dlmaxmaterials','dlmaxprograms','dl_wr2','dl_othergames','temp','links','closedlinks','system','weblogs') ORDER by page_date desc LIMIT 0, 12
#61  	1.067 ms	1459.126 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#62  	0.247 ms	1460.363 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#63  	0.496 ms	1468.478 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#64  	1.631 ms	1469.130 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#65  	2.358 ms	1482.809 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#66  	0.737 ms	1485.674 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#67  	2.286 ms	1495.295 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#68  	0.520 ms	1497.819 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#69  	0.221 ms	1512.515 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#70  	0.337 ms	1512.907 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#71  	1.116 ms	1527.252 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#72  	0.336 ms	1528.531 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#73  	0.340 ms	1537.984 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#74  	0.295 ms	1538.482 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#75  	0.201 ms	1547.460 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#76  	0.634 ms	1547.806 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#77  	0.583 ms	1558.965 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#78  	0.274 ms	1559.773 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#79  	0.817 ms	1570.005 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [17]: MySQL_cache->exists();
→ cache.php [702]: CotDB->query();	SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config'
#80  	0.369 ms	1571.024 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [277]: cot_generate_usertags();
→ functions.php [2156]: include();
→ userimages.usertags.main.php [22]: cot_userimages_config_get();
→ userimages.functions.php [24]: cot_config_load();
→ configuration.php [217]: CotDB->query();	SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ?
#81  	33.530 ms	1580.743 ms	index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [65]: cot_build_recentforums();
→ recentitems.functions.php [38]: CotDB->query();	SELECT * FROM sed_forum_topics WHERE (ft_movedto IS NULL OR ft_movedto = '') AND ft_mode=0 AND ft_cat IN ('c1','6','4','5','7','48','52','c2','46','47','21','23','50','51','c3','31','41','35','36','37','39','c4','43','44','45','c5','25','26','27','c7','42','12','22','13','11','24','30','c8','16','17','18','19','20','c9','32','3','15','14','29','10','53','c10','49','33','34') ORDER by ft_updated DESC LIMIT 10
END	1.643 ms	 

Total:1.2963s - Queries:81 - Average:0.016s/q

Added 8 minutes later:

I don't know what I'm really looking for in the above debug report but it looks to me that the NEWS and the RECENT ITEMS are taking the most time to load, is this correct? I see the biggest jump in time with these two.

→ tags.news.php [45]: cot_tag_list();
→ tags.functions.php [220]: CotDB->query();  SELECT `tag`, `tag_item` FROM sed_tag_references WHERE tag_item IN(3498,3496,3494) AND tag_area = 'pages'
#60     979.040 ms  467.845 ms  index.php [126]: require_once();
→ index.php [53]: include();
→ recentitems.index.php [41]: cot_build_recentpages();
→ recentitems.functions.php [256]: CotDB->query();   SELECT p.*, u.* , (SELECT COUNT(*) FROM `sed_com` WHERE com_area = 'page' AND com_code = p.page_id) AS com_count FROM sed_pages AS p LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid WHERE page_state=0 AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat <> 'system' AND page_cat IN ('tutorials','3d-tutorials','street-legal-modding','photoshop-tutorials','articles','legal','downloads','street-legal-racing-redline','body-mods','car-mods','decal-mods','engine-mods','exhaust-mods','interior-mods','miscellanious-part-mods','rims-tires-wheel-mods','sound-mods','suspension-mods','texture-mods','the-games','tracks','tools','patches','paint-jobs','street-legal-1','sl1-body-parts','sl1-car-mods','sl1-decal-mods','sl1-engine-mods','sl1-exhaust-mods','sl1-interior-mods','sl1-misc-mods','sl1-rims-tires-mods','sl1-sound-mods','sl1-suspension','sl1-textures','sl1-game','dlsl1tools','sl1-patches','sl1-paint-jobs','cross-racing-championship','crc-car-mods','dlcrcskins','dlcrctracks','dlcrcgmodes','dlcrcmisc','dlgom','dlgomwallpaper','dlgomvideos','dlgommisc','dlgommusic','lfs','lfsskins','lfssetups','lfstools','dl_misc','dl_iv','dl_ivcars','dl_ivpatch','dl_ivsave','dl_ivskins','dl_ivother','dl_ivtools','dl_ivcheats','dl_ivvideo','dl_ivweapon','ferrari','ferraricar','ferraritrack','ferrarimisc','dlmax','dlmaxmodeld','dlmaxscripts','dlmaxplug-in','dlmaxtextures','dlmaxmaterials','dlmaxprograms','dl_wr2','dl_othergames','temp','links','closedlinks','system','weblogs') ORDER by page_date desc LIMIT 0, 12
#61     1.067 ms    1459.126 ms index.php [126]: require_once();
→ index.php [53]: include();

Added 3 days later:

Okay so good news is that the last few days CPU stats have dropped quite a bit about %30 average from the usual average.

Added 3 days later:

no idea what to do :/

Added 20 hours later:

Is there a way to load sections of the home page after / delayed ?

The recent items and news are holding up the rest of the page from loading it seems like, is there a way to load them using ajax or some other way so the rest of the page will load on time?

Page created in 1.864 secondsSQL total time: 1.585 seconds - SQL queries: 38 - Average SQL time: 0.04171 seconds

Page created in 0.785 secondsSQL total time: 0.625 seconds - SQL queries: 37 - Average SQL time: 0.01689 seconds

Your actual problem is SQL performance. We need to analyze queries in {FOOTER_DEVMODE}.

Anyways I deleted those dead images and it helped a bit. but with that tool you linked me to, there is always a HUGE wait time for the site its self.. :(

Added 36 minutes later:

I'm looking into using expire headers for the skin files now

Added 18 minutes later:

Using some tools to check the websites performance I see this:

Resources with a "?" in the URL are not cached by some proxy caching servers. Remove the query string and encode the parameters into the URL for the following resources:

• http://streetlegalmods.com/rc.php?rc=global.nemesis.css
• http://streetlegalmods.com/rc.php?rc=global.nemesis.js

What can or should I do about that?

Added 5 minutes later:

I also see i have the option of using zend_optimizer and APC, what should I do, which one to use, or will that conflict with memcache or just not do anything?

Added 37 minutes later:

So i made some changes to htaccess to cache images and stuff etc , it looks like the score is better and the tool shows improvements, but its still complaining about the CSS and JS

Added 6 minutes later:

here is a shot from another tool also showing an issue with the CSS and JS links using "?" 

Also it complains about image dimensions , some of them are within the content but some seem to be in the CMF side, which of course I can still fix but maybe you guys would consider doing something with that for future releases? idk if thats a big deal or not

Added 60 minutes later:

Also have an option to use this

Varnish

Varnish Cache is a web application accelerator also known as a caching HTTP reverse proxy. You install it in front of any server that speaks HTTP and configure it to cache the contents. Varnish Cache is really, really fast. It typically speeds up delivery with a factor of 300 - 1000x, depending on your architecture. One of the key features of Varnish Cache, in addition to its performance, is the flexibility of its configuration language, VCL. VCL enables you to write policies on how incoming requests should be handled. In such a policy you can decide what content you want to serve, from where you want to get the content and how the request or response should be altered.

Any thoughts?

I can't always control what is hosted on my site and what isn't because a lot of the content is user submitted

That is definitely something to think about.

 had no idea about the above links button.gif.. wtf.

I can't always control what is hosted on my site and what isn't because a lot of the content is user submitted

The extension obviously has to be installed and enabled on your server, so you should check this with for example: phpinfo(); or if you have CLI access you can simply do php -m

Installing the earlier mentioned extensions is well documented and easy to find on Google.

You have a couple images linked on your site that are hosted externally.
These take a lot of time to load, and some simply just result in a 404.

Host and cache as much as you can on your own server so the browser doesn't have to constantly look up external sources.

http://wehateie.co.uk/images/button.gif
http://cheapghdflatiron.gitix.org/images/button.gif
http://cheapghdoutlet.marvellousmable.com/images/button.gif
http://hairgifts.marvellousmable.com/images/button.gif
http://ghdoutletaustraliacheap.info/images/button.gif

http://tools.pingdom.com/fpt/#!/zASEu/http://streetlegalmods.com/

Also, I wanted to ask is there a way to use memcached with cotonti ? I have that option but I am not using it..

As manuall says for `$cfg['cache_drv']` — possible values: APC, eAccelerator, Memcache, Xcache. But I'm not tested it for perfomance on production.

I would like to know more information on this, So far the adjustments I have made might of helped a bit.. but nothing too good yet.

How can I take advantage of this , how to use memcache?

Thank you

You are saying it would not be sensible to disable it for performance or it would not be sensible to keep it enabled ?

I speak about sensible for perfomance.

Also, I wanted to ask is there a way to use memcached with cotonti ? I have that option but I am not using it..

As manuall says for `$cfg['cache_drv']` — possible values: APC, eAccelerator, Memcache, Xcache. But I'm not tested it for perfomance on production.

Also, I wanted to ask is there a way to use memcached with cotonti ? I have that option but I am not using it..

Does it make a difference if I enabled or disable the recent activity plugin for the admin home page showing me last 7 days hits / new members etc ? I would like to have it enabled but disabled it for now.

Think it would not sensible. You can view list of SQL queries for certain page with DEBUG mode and {FOOTER_DEVMODE} tag. So you can compare both variants for end SQLs.

@Macik - okay , well I think the graphics are not BAD, they aren't the best I could lighten the design up more, probably more so in CSS and JS than actual image files. However, the bandwidth is in an example range, my real issues was with cpu usage.

I posted screenshots above of MYSQL stats as well as all other stats I can find, including bandwidth and most used files etc Stats above in the screens also show everything I can find right now.

Does it make a difference if I enabled or disable the recent activity plugin for the admin home page showing me last 7 days hits / new members etc ? I would like to have it enabled but disabled it for now.

First of all check Hosting statistics for MySQL if aviable or at least through debug mode on site.  

By the way what size of graphic files (site design and user personal files) do you had on site? I can help to optimize (minify) it.

Just these 3 are experimental and moreover they won't work properly on your site because they are not compatible with URLeditor plugin yet:

$cfg['cache_index'] = FALSE;
$cfg['cache_page'] = FALSE;
$cfg['cache_forums'] = FALSE;

And also, I did not purposely duplicate these threads, what happened was I posted the topic, then realized BBcode wasn't working, tried to hit back and edit the post (no idea why i did that) and when saving changes i have no idea i was posting a topic three times.

Posting images on here is a little funky but i understand now.

Added 6 minutes later:

Both of those config settings are already enabled, the template cache as well as the normal cache.

These were false, im assuming they must be since the content changes so often ?

$cfg['cache'] = TRUE;
$cfg['cache_drv'] = '';
$cfg['cache_index'] = FALSE;
$cfg['cache_page'] = FALSE;
$cfg['cache_forums'] = FALSE;

Added 3 minutes later:

News and recent items cache was both set off, so i changed them to 600 for news and 180 for recent items.

The site is somewhat active daily, so recent items especially forums and pages do change hourly, and news changes/ updates a few times a week or sometimes daily. Will this affect the new info showing up for returning visitors? How does enablding cache affect this?

Thank you

Siena is slower than Genoa out of the box simply because it has lots more in it. Here is what you should check first of all in config.php:

• $cfg['cache'] = TRUE;
• $cfg['xtpl_cache'] = TRUE;

If you have APC or Xcache or Memcached, you can also try enabling its variable cache:

• $cfg['cache_drv'] = 'Xcache'; // APC or Memcache

Then go to Administration / Configuration.

• In News plugin configuration set Cache TTL to 300 or above.
• In Recent items plugin configuration set Cache TTL to 60 or above.

If it doesn't help, then further SQL query statistics analysis is required.

A couple months ago I upgraded to Siena from Genoa 6.15 or something like that. I since noticed a huge decrease in overall website performance, load times etc.

Before the upgrade our usage was around

30-60% CPU load hourly average / daily average

200k Hits daily

I'll post some screenshot stats here so you get an idea. 

I'm wondering what actions can I take to increase the performance? I am not saying this is all due to Siena, but I just plainly have not had an issue until the upgrade. Maybe its all by chance.

What I did so far:

• I've minified and combined CSS and JS via the control panel
• I've disabled all hit / refferrer statistics that I could plugin wise (I miss having the latest weeks activity on the admin home page though)
• I've optmized all images that I could within the sites design.
• I went through the top 10 KB File Usage list to see what files were / are using the most bandwidth, I fixed some serious problems that way but that was more to do with bandwidth which is not a HUGE concern, but still something I want to control and I'm happy at the level I am at now, about 200-500GB per month, it fluctuates a lot for whatever reason.
• I checked the top list of most used files and rc.php which handles the css and js etc is pretty heavy, didn't know what to do there.

I understand I can't fix everything and even though I can make some more additional changes, it may not be worth what I give up in order to do so.

I just moved to a slightly better server, I want to see what I can do without spending too much more on hosting because my budget for hosting isn't very much at this time.

Any help is appreciated

Added 11 minutes later:

plz delete this is a duplicate, my mistake.