All,

I am developing a desktop application for Microsoft Windows using C#. I'm in
the process of designing the object model that will be used to access my
data and perform business logic related functions. However, I am currently
stuck on how to get a good balance between performance and memory usage. I
can't load everything into memory, as some tables may have thousands of
records. However, I need the ability to sort the data adhoc at runtime and
display it in a grid. I have purchased a gird from www.janusys.com that
appears to be smart enough to read only the data it is displaying (allowing
the use of disk reads of the data). However, it performs its own sorting
thus requiring the columns being sorted to be in memory for good
performance. I've been trying to design a caching strategy, but feel like
I'm reinventing the wheel. Does anyone know a good book or website that
deals with this sort of issue? I realize that there are ORM frameworks for
this kind of thing, but I prefer to stay away from them.

Thanks,
Chris