[TH] Library [Deleted]
- Thread starter Jon W
- Start date
Wildcat Media
Well-known member
@Waindigo, I had to disable the add-on on our big board since it was eating up our resources, and causing the forum to load pages in 20-30 seconds. I thought someone had gotten in and downgraded us to vB. 
The problem came from a MySQL query that was doing a LEFT JOIN. In slower periods it worked fine, but with our recent jump in traffic, it tipped us over the edge.
I am not able to grab that query, but it was a LEFT JOIN that tied a thread ID to the article, or vice versa. The Library only holds our rules, and I installed it only so that staff could edit the two pages of rules rather than figure out the confusing "pages" in XF, which is an admin feature. It is not like a lot of members read the rules anyway.
But, if that query isn't that important or could be tweaked, we could probably bring Library back online.
Beyond the performance issue we had, though, it's been a great add-on! No other complaints, and the staff finds it easy to use.
The problem came from a MySQL query that was doing a LEFT JOIN. In slower periods it worked fine, but with our recent jump in traffic, it tipped us over the edge.
I am not able to grab that query, but it was a LEFT JOIN that tied a thread ID to the article, or vice versa. The Library only holds our rules, and I installed it only so that staff could edit the two pages of rules rather than figure out the confusing "pages" in XF, which is an admin feature. It is not like a lot of members read the rules anyway.
But, if that query isn't that important or could be tweaked, we could probably bring Library back online. Beyond the performance issue we had, though, it's been a great add-on! No other complaints, and the staff finds it easy to use.
Wildcat Media
Well-known member
I don't believe so. Is that a separate add-on? Or is it a feature I may have enabled accidentally?
Jon W
Well-known member
It is an old feature that was removed and placed in a separate add-on because it was a bit problematic. I think the problems you are experiencing are due to some leftover code. I will see if I can get rid of it.
Jon W
Well-known member
The only query like this happens on the article/thread edit page, so should be relatively uncommon and shouldn't cause a server overload like this. How do you know it is that query that is causing the problem?
Last edited:
Wildcat Media
Well-known member
I was watching it stack up in the mytop script. And nobody has edited those articles in a few months. I would probably recognize the full query if I saw it.
I wish I had been able to capture it in mytop but we had to get the forum running properly.
Last edited:
bobs409
Active member
Are there any plans to make improvements to this add on?
After using mine quite a bit (and loving it
) I'd like to suggest a few possible improvements:
1) Show on forum index page when new articles are posted either with a NEW icon or by using the default forum node icons as well as show any new additions on the recent activity list.
2) Show how many page views each article has had and when it was created.
3) Ability for the admin to organize the order of how the articles show on the library index page.
Thanks,
Bob
After using mine quite a bit (and loving it
) I'd like to suggest a few possible improvements:1) Show on forum index page when new articles are posted either with a NEW icon or by using the default forum node icons as well as show any new additions on the recent activity list.
2) Show how many page views each article has had and when it was created.
3) Ability for the admin to organize the order of how the articles show on the library index page.
Thanks,
Bob
oVR
Active member
I would be interested in contributing!
Some things I would like to see:
More thread like layout with last post icon, last post date, etc. It would remove the need for a forum within a library since the library can now be a standalone piece.
Comments loaded underneath container of the article much like in Xen Media Gallery or XenMedio
Import/move forum thread into Library and keep the comments but allow author/moderator to edit the article itself like adding pages, etc.
Sidebar with "More articles by this user" with ratings, recent articles, etc very much like the resource manager.
Jon W
Well-known member
Waindigo updated Library by Waindigo with a new update entry:
Version 1.3.9 released
Read the rest of this update entry...
Version 1.3.9 released
Read the rest of this update entry...
Wildcat Media
Well-known member
Were you able to track this bug down? All I can offer is that once I disabled this add-on, the query went away and the database congestion ended immediately.I was watching it stack up in the mytop script. And nobody has edited those articles in a few months. I would probably recognize the full query if I saw it.
I wish I had been able to capture it in mytop but we had to get the forum running properly.
I just want to know if i should keep it installed or just uninstall it. We were only using it for our forum policies, and I only chose it since it was easy for staff to modify documents and did not need admin permissions. I can find some other way, not a big deal, you have other add-ones that need your attention.
Jon W
Well-known member
I have improved the code slightly. Let me know if it helps.Were you able to track this bug down? All I can offer is that once I disabled this add-on, the query went away and the database congestion ended immediately.
I just want to know if i should keep it installed or just uninstall it. We were only using it for our forum policies, and I only chose it since it was easy for staff to modify documents and did not need admin permissions. I can find some other way, not a big deal, you have other add-ones that need your attention.
Jon W
Well-known member
ManOnDaMoon
Well-known member
Is this still supported? I can see options to toggle sticky article thumbnails, I found a Waindigo/Library folder under the Extend directory, but nothing letting me specify a URL at article creation/edit time.
Similar threads
