Forums / Cotonti / Support / Tips for better performance with Siena ?

<<<12

Upgraded to Siena from Genoa, using much more resources than before

singh336
#16 2014-01-28 18:43

Members

Okay, when should we do this, or is this something I should do and show you the results ?

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.

 

 

1658201_10151866519141246_1489084468_o.j1622003_10151866493801246_1471887119_n.j You can see the cpu stats dropped regardless of the increased traffic / activity on the website during the same days, which is good news to me. also looking at the stats its very clear we get little unique hits versus the amount of "hits" total which means i should heavily benefit from proper caching ... I added this code to the HTACESS file in the root of the website, im not sure if this was a good idea or not.. what do you think.. Header unset ETag Header unset Last-Modified FileETag None Header unset Cache-control Header set Expires "access plus 1 month" The difference I noticed was that the background image on my website seems to quickly load when im clicking around pages, and that doesn't seem like a good thing, i was expecting an instant load for most if not all the graphics on the sites theme design... Any advice on how to do these expire header / browser leverage caching the right way with siena ?

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?

<a href="http://www.streetlegalmods.com/">http://www.streetlegalmods.com/</a>

Dit bericht is bewerkt door singh336 (2014-02-04 18:48, 10 jaren ago)
Twiebie
#17 2014-02-04 23:10

Team
Bedankt: 74 tijden

#39106 singh336:

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

Dit bericht is bewerkt door Twiebie (2014-02-04 23:38, 10 jaren ago)
singh336
#18 2014-02-09 20:18

Members

Yeah I did that as soon as trustmaster suggested

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

 

 

<a href="http://www.streetlegalmods.com/">http://www.streetlegalmods.com/</a>

Dit bericht is bewerkt door singh336 (2014-02-18 22:57, 10 jaren ago)
tensh
#19 2014-03-17 09:00

Contributors
Bedankt: 12 tijden

I have a performance-related question for experienced developers:

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?
Alex300
#20 2014-03-17 17:56

Administrators
Bedankt: 200 tijden

Second will be much better
 

Есть миры, не здесь, там, где небеса горят, и моря засыпают, и реки дремлют; люди сделаны из дыма, а города – из песен. Где-то опасность, где-то несправедливость, даже где-то остыл чай. Идем Эйс, у нас много работы!...
...Sorry for my english...
Бесплатные расширения для Cotonti: https://lily-software.com/free-scripts/
tensh
#21 2014-03-18 08:13

Contributors
Bedankt: 12 tijden

Thank you very much for an answer :)

<<<12