By Attila Lengyel on Thursday, 12 June 2014
Replies 10
Likes 0
Views 1.3K
Votes 0
Hey guys,

Since you are on an improvement roll lately, I figured I had to share some of my ideas with you.
This time, it is related to your built-in point system. As you know, when a user gets a point, it is logged into the database's corresponding table. Thus, every single point achievement is stored securely. Imagine it for hundreds or for thousands of users.. That's a big load for any servers.

If we could have an option like merging point history from a specified date, well, for example instead of loading 50 or 120 entries, users would see a single line, like a closing balance. On one hand, it would be a "new feature", on the other we could save valued time, sources, we could reduce DB calls and datas to be loaded (for both backend and frontend), hence the site's performance and speed would be even better.. Tell me if i'm wrong :P
It could also come handy, if administrators were able to delete a single point history, as you have for Badges now.

Of course, please note that this is just a suggestion, obviously not a priority one, but hope it can be useful for many users / admins out there & you will find it worthy for EasySocial to keep advancing.

http://stackideas.com/voices/easysocial/item/168

Thanks
Hello Attila,

Yeah, this seem like a pretty good idea. Perhaps instead of having it done per-user basis, we could add a maintenance script that allows you to merge all the history. However, the points history on the front end would look weird after that though since there will only be 1 item.
·
Friday, 13 June 2014 02:57
·
0 Likes
·
0 Votes
·
0 Comments
·
I like this idea. AlphaUserPoints has this as combined activities but for ALL users which I used once a year. I don't think users will have a problem if you do this periodically. They would not care to see a point detail they earned from many months ago but only recent items.
·
Friday, 13 June 2014 05:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Noted, thanks for the heads up on this
·
Friday, 13 June 2014 10:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey guys,

Many thanks for your replies.

Perhaps instead of having it done per-user basis, we could add a maintenance script that allows you to merge all the history. However, the points history on the front end would look weird after that though since there will only be 1 item.

@Mark, this would be a great solution. Running maintenance scripts is just a click, so that could be a time-saver. Nevertheless, the frontend with one item would be just temporary. If you perform such actions as an admin, and close the balances one minute, in an active community users would recieve points in the other minute. So logging points is a continuous process, yet the database shouldn't load hundreds of previous items.

I don't think users will have a problem if you do this periodically. They would not care to see a point detail they earned from many months ago but only recent items.

@John, you are also right. While I was using AUP, I always closed balances for users in the last days of every month. They were really happy about it. Why? Because even if they were curious what's going on at their point history, I assume they would not want to go thru e.g. 30 pages to see all the history from the previous month. As you say, they only care about recent items and the balance they gained is the most important.

Hope you don't mind sharing my views about the topic, but we are on the right track in optimising EasySocial, and even if it's not a huge change, still could save some sources. Thanks for listening.

All the best guys,

Attila
·
Friday, 13 June 2014 14:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for the heads up on this Atilla
·
Saturday, 14 June 2014 15:44
·
0 Likes
·
0 Votes
·
0 Comments
·
No problem Mark :-) Hope it was helpful
·
Saturday, 14 June 2014 20:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Yep, it definitely is helpful
·
Saturday, 21 June 2014 14:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Alright then. Glad you liked it.
·
Saturday, 21 June 2014 17:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark,

I have just checked your roadmap and I was pleased to see, you have already made a maintenance script to merge all user points history into one That was fast guys, that was fast Cannot wait the new beta to play with it. Big 'thank you' for the whole team!
·
Sunday, 06 July 2014 23:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks
·
Monday, 07 July 2014 01:28
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post