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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
