Hi You could do both, but I would use one schema. (the title of the mail is incorrect: many schemas is many tables, which is what I would avoid).
Regards, Thomas Am 12.09.2013 17:54 schrieb "Pablo Beltran" <[email protected]>: > 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. > -- 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.
