say you have two entities A and B, and the relationship is one to many
the two entities are fairly large. how do u get a reasonable perfomance when loading entity B given that for one instance of A there can be many instances of B, by many i am talking of tens and thousand instances for example 100 000, is there a good pagination solution that will enable the programmer to navigate the collection, get a count without loading all instances.
