Hello. I have a question. I'm developing a program and I would like how to improve my db scheme desing. Currently I'm developing a movie manager program with 20 tables. The main table is the movie table with 30 fields.I'd like to know whether I should load the entire table into a movies object list or it would be better if a loaded only the ids, and when the user scrolls down the movies list, go and load the rest of the fields.
In other words, should I go for a list of Movies Objects, with 30 fields as members of Movies objects, or only a Movie object with the id field, and do lazy loading as requiered. Thanks in advance. -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.