blog documentation FAQ followers forum marketplace services youtube

solved More performance questions

The Jamroom Network » Forum » Jamroom Developers » Page » More performance questions
alt=
DannyA
@dannya
7 years ago
584 posts
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
brian
@brian
7 years ago
10,148 posts
DannyA:
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?

This is Jamroom's user sessions, and it already uses a session cookie. You're not going to be able to reduce these calls in any way, other than offloading them to a new session handler (which is coming with the Redis module in JR Cloud 2.0).

Every single request by a logged in user will trigger a write to the session DB - that's how PHP sessions work.

Let me know if that helps.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
alt=
DannyA
@dannya
7 years ago
584 posts
Yes. Thanks.

Tags