Olexandr, I fear that model may not scale well. Certainly having data
spread across so many different tables reduces the effectiveness of memory
caching.
I recommend you alter the design to have 30 tables total, each with a column
for user id, rather than 30 tables per user. This may improve pe
Hello,
I am working on hosting solution for a popular open source script, where
users can sign up and get an own forum. We use InnoDB, and each user has an
own set of tables (around 30); there are currently around 500 users
registered. Despite the large count of tables, database is small, around
