Forum Activity for @dannya

More performance questions

Jamroom Developers

We've been looking at some ways to improve our DB performance. Our logs are showing A LOT of calls to INSERT INTO jr_jruser_session. How can we identify and reduce the number of calls being made. What is inserting? Are there ways of saving more of that information in a cookie for example?
updated by @dannya: 06/16/17 04:00:34PM

Load balancing multiple servers

Using Jamroom

Actually getting page not found on documentation link for many modules.. The ones i found so far:
https://www.jamroom.net/the-jamroom-network/networkmarket/64/playlist-ads
https://www.jamroom.net/the-jamroom-network/networkmarket/113/daily-limits
https://www.jamroom.net/the-jamroom-network/networkmarket/155/media-limits

Load balancing multiple servers

Using Jamroom

What's the redis cache? I found a link to details in jamroom site search but its broken

Load balancing multiple servers

Using Jamroom

Ya. The conversion servers were just an example because the are especially resource intensive. But the example is ideal because if you have one service (module?) that requires a disproportionate amount of a resource, it's nice to be able to scale it separately. You can do it today but just enabling the modules you need; it's just that you have to deploy a full node to handle one service and that carries an administrative and resource overhead. It's not wrong, just not optimal for certain functions.

Caching queries

Jamroom Developers

Ah. great. thanks.

Caching queries

Jamroom Developers

Ok. So how does the cached results get refreshed? Is there a TTL setting?

Caching queries

Jamroom Developers

Can you describe a bit how JR caches queries? I have some custom modules that seem to be slowing things down quite a bit. I suspect they are querying the db every time rather than have the results cached.
Do you need to do anything in particular to have JR cache the results?
How often will JR query results check for changes? Is there a TTL of the result that can be set?

For example, a query of most popular songs measured by likes. I assume we don't query the DB for that every time. We should be able to cache the results of that and deliver the same chart. How often is the results of that refreshed in the cache?
updated by @dannya: 06/15/17 05:29:29PM

Disk space calculation

Jamroom Developers

Bumping this

Dashboard links

Suggestions

It would be great to modify the dashboard so if you clicked on a metric, it would take you to it's admin page (instead of letting you switch the content of the box). e.g., licking on #3of profile take you to the profile browser
updated by @dannya: 06/12/17 06:30:38AM

Disk space calculation

Jamroom Developers

Yeah saw that, but questions still stand.