14
Right now I have no time for deep tests, maybe tommorow, but here is what I can do in hurry:
Categories: 6054
Articles: 13465
Here is debug from admin part of Publisher (renamed as Smart Section because the site was running on it before). This is just first page of articles of 898.
Memory usage: 181365928 bytes
Admin Categories page:
Memory usage: 41213088 bytes
When I try to go to admin > articles I got:
Fatal error: Call to a member function getCategoryLink() on a non-object in C:\wamp\www\rehab\modules\smartsection\admin\item.php on line 254
Call Stack
# Time Memory Function Location
1 0.0012 964840 {main}( ) ..\item.php:0
My localhost apache is set to 4000M
This is from debug:
Quote:
0.000226 - SET NAMES 'utf8'
0.000119 - SET SQL_BIG_SELECTS = 1
0.000664 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000263 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'hqj5mnko023bsoe5br4fpeudm2'
0.000187 - SELECT * FROM users WHERE uid = '1'
0.000328 - SELECT * FROM modules WHERE dirname = 'smartsection'
0.000898 - SELECT * FROM config WHERE (conf_modid = '6') ORDER BY conf_order ASC
0.000430 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000335 - SELECT * FROM modules WHERE dirname = 'system'
0.000616 - SELECT * FROM config WHERE (conf_modid = '1') ORDER BY conf_order ASC
0.000391 - SELECT * FROM modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
0.000341 - SELECT * FROM modules WHERE dirname = 'protector'
0.000220 - SELECT * FROM modules WHERE mid = 2
0.000328 - SELECT * FROM modules WHERE dirname = 'publisher'
0.011003 - SELECT COUNT(*) FROM smartsection_items WHERE ((status = '1'))
0.011242 - SELECT * FROM smartsection_items WHERE ((status = '1')) ORDER BY datesub DESC LIMIT 0, 15
0.034258 - SELECT * FROM `smartsection_categories`
0.005668 - SELECT * FROM group_permission WHERE (gperm_modid = '6')
0.008035 - SELECT COUNT(*) FROM smartsection_items WHERE ((status = '2'))
0.010027 - SELECT * FROM smartsection_items WHERE ((status = '2') AND datesub <= '1354381488') ORDER BY datesub DESC LIMIT 0, 15
0.000270 - SELECT * FROM smartsection_categories WHERE categoryid = '5'
Total: 21
and the timers:
Quote:
XOOPS took 1.787 seconds to load.
XOOPS Boot took 0.019 seconds to load.
Module init took 0.027 seconds to load.
XOOPS output init took 0.007 seconds to load.
Module display took 1.734 seconds to load.
I've updated publisher (cloned under smartsection name in fresh installed Xoops) and updated the module.
When I swich to frontend in modules/smartsection (publisher)
Memory usage: 21685240 bytes
Category with 50 subcats and I dont know how meny subsubcats:
Memory usage: 182692208 bytes
Finally, an article:
Memory usage: 180683656 bytes
That is all for now.