Hi, I need to store lot of data (even millions of records) on an small bunch of tables for many users (thousands). What would be would be the best approach?
1. Create one schema per user, so each user would have its own private table: select * from USER_N.TABLE_X 2. Create one table shared by all the users and add a new column to identify the data by user: select * from PUBLIC.TABLE_X where user=N; Thanks! Pablo. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
