ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Yoffe" <byo...@houston.rr.com>
Subject RE: Cache entire table for use in an application
Date Wed, 23 Nov 2005 01:43:18 GMT
Perhaps you should look at an in memory database such as times ten, etc.

-----Original Message-----
From: Niels Beekman [mailto:n.beekman@wis.nl]
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:maillist@roomity.com]
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.



Mime
View raw message