i want to create a dataGrid that has X items (read from a DB), but that only holds Y items in memory at one time. The range of values is in the millions, so i'm trying to lessen the number of items i have in memory at once so as to not degenerate the performance. I may change course later, but i want to see this through for myself!
anyways, if i have, say, 2 million items in the DB and want to display only 1000 at a time, is it possible to tell the dataGrid to display as though it has 2 million, thus enabling a large vertical scrollbar, when i only have 1000 items in the actual data provider?
any help is appreciated.
I haven't done any work with this; but perhaps I can point you in the right direction.
What your asking for is sometimes called Lazy Loading. You'll need something on the server that can communicate with the front end to tell it when to load more data.
I believe that LiveCycle offers features for this type of approach. The dbHibernate project also has some lazy loading suppor ( http://code.google.com/p/dphibernate/).
awesome. thanks. i needed that word 'Lazy Loading', so now at least i can try more specific google searches.
Thanks for the LCDS info. I'll look into that. I'm trying to implement it in Java on my own. i know i shouldn't try to reinvent the wheel, but i'm not entirely sure this project will be able to afford LCDS with it in the end, so i'd like to learn how to do it myself first.
any other links or info is appreciated. thanks!