Forum Activity for @brian

Archive and Purge

Jamroom Hosting


Sorry if I gave that impression - of course a smaller DS will always perform better on inefficient queries so it makes sense to archive records if your use case requires lists that use a larger number of search conditions.

Archive and Purge

Jamroom Hosting


It could, but it's not that clear cut.

To be honest the calls on your site that are slowing things down are not the comments that are being listed in a specific topic - that's no problem - those will remain fast even with millions of comments. It's the lists of the type "here's the latest comments on discussions in our community profile that are related to US politics" - that requires more search conditions, which means it is going to be slower.

So if you were to attempt to do those types of lists using the Forum, you might run into the same issues.

Archive and Purge

Jamroom Hosting


Exactly. So when you start facing performance issues, the first thing to do is figure out how to be "less fancy". For example, the front page of your site right now has 13 different site builder blocks on it - 8 of them are lists. Are they all really needed? Look at Reddit - it's ONE list. If they tried to slice their data 8 different ways on every page they could never scale.

I know this isn't something you can decide on immediately, but it's something you can do over time that can really help your site scale better. Focus on reducing the number of unique listings - this gives you a better chance of having a smaller cache with a higher hit rate.

Archive and Purge

Jamroom Hosting

Note that we have sites that have more than twice as many comments as your site that are working well. What you have to do as you get bigger is start to reduce/refine the number of different ways you are presenting the data. A good example is moving to "simplepagebreak" instead of "pagebreak". Once you have thousands of pages it just doesn't make sense to have a jumper - no one is saying "I want to jump directly to page 1,267". The simple pager is much, much faster since it does not have to know exactly how many pages there are - it just adds prev/next page links.

I know on your site you are using the jrDiscussion module, which to be honest is always going to have more performance issues than our Forum module since it is a combining of 2 different datastores. However, the recent comment 2.0.0 update should have sped things up considerably for most "normal" views.

Any tool that we would make that archives comments would work correctly. Just note that I'm not sure why you would want to archive them instead of just deleting them, unless at some point you want to be able to browse through the old comments i the DB.

Audio Files not getting processed and player not loading.

Design and Skin Customization

If sox is not working correctly, your conversions are not going to work correctly. You need to be on hosting that supports all of the System Tools.

updating template to jrCore_item_detail_features doesn't display prior entered tags

Using Jamroom

Switching to the jrCore_item_detail_features function would not impact the tags that show. Do you have A LOT of tags? There is a limit in the tags, so if you have a lot of tags for an item only the most popular X will show (I think it is 50).

Group members unable to access Group Discussions intermittently

Using Jamroom

This should be fixed now - root cause was the worker process in the comment module that needed to add some new compound keys to the comment items was exiting early since your site has 1 million+ comments.

Stream Pay with PayPal

Using Jamroom

It's in the stable channel and will show up in your marketplace:

https://www.jamroom.net/the-jamroom-network/networkmarket/245/stream-pay

Archive and Purge

Jamroom Hosting

We have tools for deleting items, but not archiving items. For comments you could just export an SQL dump of the item and item_key tables as your archive - I think that would work.

Are you wanting to do it for performance reasons?

Thanks!

Audio Files not getting processed and player not loading.

Design and Skin Customization

Sounds like the conversion workers are stuck - run an integrity check with "repair modules" checked - that should fix it up. This can happen if there's a conversion in process and the worker process "bombs out" due to a server or web server restart. The next core release has an update to the hourly maintenance check to watch for this and should be able to automatically fix it, but for now the integrity check should help.