Unfortunately, our friend said he didn’t know how to use ruby on rails and I had to try to solve the problem by myself. 
I am trying to create a new table to store available points, otherwise it will calculate the total from the points table every time. As well, index of user points table is needed (it has 230,000 rows you know)
My hunch is an index will help but won’t be enough. What this really needs is a fact table.
I implemented something similar but used a fact table and jobs to pre calc the results so it wasn’t causing load on page retrieve.
Oh Robert, Could you please submit a PR? I may help me a lot. 
No time for that I’m afraid. It’s relatively involved.
I’m too busy with our free software as it stands.
1 Like
Thank you any way！
Could let me look at your work? Maybe it could be reference. 
That was closed source client work unfortunately
Oh I’m sorry.
Thank you very much any way!
1 Like