21
Yurdal
Re: Latest Publisher module?
  • 2012/11/28 15:37

  • Yurdal

  • Friend of XOOPS

  • Posts: 386

  • Since: 2005/3/27


@Trabis
Nice to see you around again :)

I think somethings are changed in sourceforge , i cant download the publisher trunk anymore, i used downloadSVN software before and that wasn´t any problem now i cant downlaod it , is there a way do download this version Publiser ?

22
bjuti
Re: Latest Publisher module?
  • 2012/11/30 13:40

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Any progress this days? :)

23
trabis
Re: Latest Publisher module?
  • 2012/11/30 13:57

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Quote:

Yurdal wrote:
I think somethings are changed in sourceforge , i cant download the publisher trunk anymore, i used downloadSVN software before and that wasn´t any problem now i cant downlaod it , is there a way do download this version Publiser ?


The link to checkout publisher is :
https://svn.code.sf.net/p/xoops/svn/XoopsModules/publisher/trunk/publisher

I don't think this svn version has a download link so you will have to use tortoisesvn.

@bjuti,
I don't know when I'll have time to add features to publisher. Right now I'm resuming work on xoops 2.6 and I'm out of schedule. This current version of publisher should solve your memory usage issues.

24
bjuti
Re: Latest Publisher module?
  • 2012/11/30 23:51

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


@trabis I ment memory issue because I've tried actual svn version and still uses a lot of memory. You said about update script that removes permissions of items? No new features for now, just make it less memory consumable :)

Tnx!

25
trabis
Re: Latest Publisher module?
  • 2012/12/1 1:38

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Quote:

bjuti wrote:
I've tried actual svn version and still uses a lot of memory.


I'll have to test publisher with 50k entries to see if I can find a leak!

26
bjuti
Re: Latest Publisher module?
  • 2012/12/1 12:56

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Tnx mate!

27
trabis
Re: Latest Publisher module?
  • 2012/12/1 16:32

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Hi bjuti, here are some reports I have:

This is the report for the publisher index page memory usage:
Memoria usada: 9743088 bytes (publisher empty)
Memoria usada: 11897200 bytes (publisher 100 cats);
Memoria usada: 16787912 bytes (publisher 205 cats, 203 items);
Memoria usada: 18895848 bytes (publisher 205 cats, 6203 items);
Memoria usada: 18892768 bytes (publisher 205 cats, 11203 items);
Memoria usada: 18891768 bytes (publisher 205 cats, 19203 items);

As expected, adding categories (permissions) will affect memory usage. Since we are not using permissions for items, the memory usage is not affected byt the number of items in the system.

Now a page by page report, 'homepage blocks' means all publisher blocks in front page, the second reading is for memory peak usage
(publisher 205 cats, 19203 items):
indexpage Memoria usada: 18878384 bytes - 20479560 bytes
categorypage Memoria usada: 19696600 bytes - 21262592 bytes
itempage Memoria usada: 14144944 bytes - 15769624 bytes
homepage blocks Memoria usada: 18003952 bytes - 21012656 bytes
userinfo Memoria usada: 13132304 bytes - 13774056 bytes
Archive Memoria usada: 8618544 bytes - 17425056 bytes
Archiveyear Blankpage
Search lorem Memoria usada: 13132472 bytes - 13774728 bytes

(publisher 205 cats, 50203 items, space of total items in db = 146.5 MiB;
indexpage Memoria usada: 18875512 bytes - 20481440 bytes
categorypage Memoria usada: 20029424 bytes - 21982304 bytes
itempage Memoria usada: 14142216 bytes - 16141784 bytes
homepage blocks Memoria usada: 18009448 bytes - 21020552 bytes

As you see, memory usage is quite low, around 20Mb and is not affected by number of items. (expect on archive, see above)
However there are some slow queries that need to be fixes, also, the archive is exhausting memory.

Could you share some of your memory usage info?
Did you update module after uploading new files?
How many categories do you have?
How many groups have permissions to read categories?

We could speed publisher by adding option to ignore read/access permissions on categories. This would be useful for sites that have all the categories readable for all groups.

28
bjuti
Re: Latest Publisher module?
  • 2012/12/1 17:13

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


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.

29
bjuti
Re: Latest Publisher module?
  • 2012/12/1 17:17

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


Alo I have one running site with 573 categories and 4200 articles but I didn't swich it to new publisher version because I don't know is it safe changing the database with permissions issue, and I had no time to backup.

I can get you debug from it, but i'm not sure does it make sense.

30
bjuti
Re: Latest Publisher module?
  • 2012/12/1 17:23

  • bjuti

  • Just can't stay away

  • Posts: 871

  • Since: 2009/1/7 2


I forgot, for first localhosted website I have no permissions because I was testing few days ago, so I'll get you another report when I do webmaster and anonymous permissions.

One info, when i go to admin / permissions:
Memory usage: 89525656 bytes

Login

Who's Online

209 user(s) are online (133 user(s) are browsing Support Forums)


Members: 0


Guests: 209


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits