Recent files
Load Time on Aggregate Pages [Solved]
I've consistently had load times in the 15-30 second range on several pages.
Solution has been fully integratedSolution Manager: Bernard
Issue description
The Recent Comments page, and the Recent Articles Post page are taking extremely long to build, and have as long as they've been on my site.
Interestingly, they're the most useful and used pages and people do tolerate the obscene times on those pages.
I put this here thinking that it seems like a bug to have a page take so long to build. I'm not sure what you can do to fix the load times on them, but it seems something that should definitely be addressed in the future, whether it is technically a bug or not.
http://www.shakespearesmonkeys.com/articles/
http://www.shakespearesmonkeys.com/comments/
Interestingly, they're the most useful and used pages and people do tolerate the obscene times on those pages.
I put this here thinking that it seems like a bug to have a page take so long to build. I'm not sure what you can do to fix the load times on them, but it seems something that should definitely be addressed in the future, whether it is technically a bug or not.
http://www.shakespearesmonkeys.com/articles/
http://www.shakespearesmonkeys.com/comments/
Files
Comments
Bernard from nearby-an-airport Associate 6555 posts registered on Sep. 12 2003 |
27 seconds to build the index of articles, that's quite a lot... Your site features a quite high number of pages, but that's no reason. What can be done? First, you are encouraged to optimize the database back-end. This operation consists to re-order records in data files, re-create index files, etc. To achieve this in YACS go to the Control Panel, select the System tab, and click on the Maintenance link. Second, we are still improving YACS to reduce the burden it puts on server CPU and memory resources. Many ISPs just limit the amount of resources one site can use, and this translates to execution delays for demanding scripts. At Blue Host, they even block execution if your scripts take more than 40 seconds CPU during the last minute... Key scripts have been profiled in YACS 8.1 to save CPU cycles, and to ask for less memory. At the end of the day, this should also help a lot in your situation. |
AnsteyER Member 274 posts registered on Jan. 22 2007 |
I run the maintenance several times a week. |
NickR from West Yorkshire, UK Member 327 posts registered on Aug. 17 2006 |
Hi. Do you have caching enabled. This website has a large amount of articles and doesn't appear to have any performance issues with the article and comment index pages. Nick My Website: NGR78 |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
NickR: Yes, caching is on. I'm more than happy to give temporary associate access if it would help you understand the settings i have and the performance. |
| Bernard from nearby-an-airport Associate 6555 posts registered on Sep. 12 2003 |
The action plan should be to migrate to yacs 8.1, presumably by end of next week, and to check where we are afterwards. |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
As soon as 8.1 is ready, i'm upgrading. |
| NickR from West Yorkshire, UK Member 327 posts registered on Aug. 17 2006 |
Hi Could you please try out index2.php and index3.php in the attached zip file. Place them in your articles folder on your site. I suspect there is an issue with paging. Cheers, Nick Nick My Website: NGR78 |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
I upgraded tonight and if anything the pages both slowed down. Then i noticed your note here about using the two pages. Index2.php did absolutely nothing for me as far as i could tell it's load time was 26 seconds. index3.php was amazing. I see that it has lost the pages. on the top..but i'll give that up for a .22 load time. That is a dream. I'm going to use it for now. If you have any solution for the comments page let me know. this solution while not ideal is FAR better than the wait for the load. |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
That paging that you removed -- that absolutely solves the problem. It makes the page much less navigable, but it makes it work. I wonder if all of the sections i have that are slightly slower is related to this problem. the worst offender right now is the /comments/index.php |
| NickR from West Yorkshire, UK Member 327 posts registered on Aug. 17 2006 |
Hopefully Bernard will be able to review the paging code and spot any bugs. Nick My Website: NGR78 |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
I commented out line 61 in the index page of /comments and that seems to have speeded up that page significantly. as a note, this morning when i went to access the pages, the initial load was slow (8.9sec), but subsequent loads were speedy. That suggests to me that the cache helping significantly. |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
Just as an FYI: THe times haven't not remained as good. They have definitely slowed down. |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
Hrm. I haven't changed anything since the initual change and now, i'm back to 20-40 seconds per load. |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
I ran maintenance and that sped things up again. BUt I have no idea for how long. I'll keep this thread posted. |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
Ok, i'm officially despondent that it didn't fix the problem completely. It seems to fix it for a few minutes after maintenance, but after a few clicks it's back to VERY slow again. |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
I went into php.ini and bumped memory to 32MB without any noticable effect on this problem. (though it did allow my ajax stuff to start working again after it mysteriously stopped working earlier) |
| AnsteyER Member 274 posts registered on Jan. 22 2007 |
I upgraded php to 5. I had another weird melt down with tiny_mce which required me taking a copy out of staging and using that. I could not get the one on the site to work I have had to delete the browser_minify.js file 3x to get the tabs working, it seems after each attempt to work on the php.ini file something happens that just isn't good there. the end result of all this: still 25sec+ loads on both those pages. the new index files didn't help for more than a few minutes. and the behavior went right back to the same. |
| Bernard from nearby-an-airport Associate 6555 posts registered on Sep. 12 2003 |
Currently the index of articles at your site is loaded in around 1.1 seconds, so I close this issue... |
Reply
Quote
18 comments · 
Add a comment
Rate this page
Posted by AnsteyER on Jan. 23, page edited by Bernard on June 14, (popular)
