I have been using SmartSection 2.14 for article management for a while now, but in the past few months I have noticed a gradual slow down in performance when accessing each of the articles or when listing them in the administration menu.
To begin with the module performed well, however as I started going over 1 000 rows in the database, I noticed a slow down when performing searches on the site or accessing the articles, some of the wait times according to the XOOPS timers were around 5 seconds. I am now approaching 10 000 rows so the slow down is now becoming significant, near 10 seconds on loading an article.
I have attempted to optimize some of the code in item.php as an example by reducing the number of category and item objects being created, and trying to only create an object for the item currently being viewed. This had worked very well at around 6 000 rows and for a time this had brought the load time down from 10 seconds to around 4 seconds.
However as the number of rows has approached 10 000, the slow down has begun growing again, albeit at a slower rate.
My question really is, what happens in the Module Init phase when a page loads in XOOPS? This is the phase that consumes the most time when loading an article. If there is a procedure in the code that is causing the long load times, I need to find it soon and make the necessary changes. I have made some of my own pages selecting the items from the database, and these are nowhere near as slow as /modules/smartsection/item.php and /modules/smartsection/admin/index.php
Much appreciated.