Cache entire table for use in an application

[ooper]

Is there a nice way to load an entire table into memory and then execute queries against what's in memory instead of executing queries against the database?
(I'm using SQLServer.)

TIA, Brian Barnett


Broadband interface (RIA) + mail box saftey = http://iBatis_for_Java_Users_List.roomity.com
*Your* clubs, no sign up to read, ad supported; try broadband internet.