[OLIO-51] Increase scale/size of database

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: generic
• Assignee: Shanti Subramanyam
• Reporter: Shanti Subramanyam
• Created: 02/Feb/09 23:36
• Updated: 19/Mar/09 17:39

Description

1. Currently, the database holds 10x the number of connected users as the number of rows in the persons table and all other row counts are tied to this same parameter. Web2.0 sites tend to have a very large number of registered users compared to the active user population at any time. As such 100x seems to be a more realistic ratio to use. So if the application is running 1000 concurrent users, it will actually have 100,000 registered users.

2. Even with the above change, the space consumed by the DB is quite small due to the rather smallish schema. If we want to test realistic db sizes, we should pad the various tables or add new tables to the schema.

Of course, we do want to keep things in perspective, recognizing that this is a sample app and we cannot really afford to load and test terabyte scale dbs.