Save State - How will this affect database size?

Submitted by etherscreen on Sat, 10/12/2019 - 18:51
Forums: 
General discussion

I'm going to create about 5,000 dialog cards using spaced repetion where the user's state is saved.

I have about 5,000 active users on our site. I can see each user completing all of the dialog cards multiple times.

How will this affect the database as well as site performance (we're on AWS)?

Thanks!

icc's picture

icc

Thu, 10/17/2019 - 16:42

I do not think you will notice much of an impact. 
Storing the state happens via AJAX and I would guess it's seldom larger than 100-200 bytes. E.g. if all of your users take all of the cards you'll probably end up with 5 GB of stored data, which I think is unlikely. I'd be surprised if you surpass 1 GB.