@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 ?

Any progress this days? :)

Quote:

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.

@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!

Quote:

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

Tnx mate!

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.

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:

and the timers:

Quote:

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.

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.

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