Save State - How will this affect database size?

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)?


icc's picture

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.