Hi Rami, Thank you very much for the answer, but I still don't understand much about the two tables, which you recommended.
For example: My original database: ----------------------------------- userId | Friends ------------------------------------ user1 | user3 user2 | user3 user3 | user1, user2 ------------------------------------- The new tables are: Userdata: ---------- userId ----------- user1 user2 user3 -------- Friends: ---------------------- friendId | userId ------------------------ user1 | user3 user2 | user3 user3 | user1 user3 | user2 --------------------------- 1)In this Example the user1 and user2 has the same friend user3, so the "Friends" Table needs more space then the first ARRAY Type. Isn't it? 2) Why do I need the table "Userdata" ? I can easily use "select * from Friends where userId = ???" and get all the information. Will the Table userdata speed up the selection? May be my questions are very stupid... I am really new in database. :( -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/kNJ1EmbkyW0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
