Perhaps you should look at an in memory database such as times ten, etc. -----Original Message----- From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 22, 2005 5:46 PM To: user-java@ibatis.apache.org Subject: RE: Cache entire table for use in an application
Nope, that's why database servers got invented :) Of course you can cache the objects, but that was probably not your question. The MS SQLServer documentation contains lots of information about how it uses memory for caching, maybe you should take a look at it. Niels ________________________________________ From: ooper [mailto:[EMAIL PROTECTED] Sent: woensdag 23 november 2005 0:43 To: user-java@ibatis.apache.org Subject: Cache entire table for use in an application 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.
