For an example let me say that I have a big (over 1 million) user "base". Then every user does a lot of inserting/updating of data. Would it be better to create different tables for insert/updating for every user or would it be better just to have one big table with all data (tables would have of course the same columns, ...). How do you cope with this kind of things?
2. example (a big number of tables) tablename_user_id( id, datetime, some_data)
Although there isn't enough information in the email, but instead of creating a separate table for every user, you could use one table , partitioned on userid, that would , however, add a maint overhead whenever you add a new user.
Thank you.
Kind regards,
Rok
---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ?