Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Content-class: urn:content-classes:message
Subject: RE: Cache entire table for use in an application
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Date: Wed, 23 Nov 2005 00:45:33 +0100
Message-ID: <50CA25BD6EEA954FA592C097399942E3093137D9@CM1.wis.local>
Thread-Topic: Cache entire table for use in an application
Thread-Index: AcXvvlGuOZDzSmqsRK+pB0SgnHdjIAAACmRQ
From: "Niels Beekman" <n.beekman@wis.nl>
To: <user-java@ibatis.apache.org>

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]=20
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 =3D
http://iBatis_for_Java_Users_List.roomity.com
*Your* clubs, no sign up to read, ad supported; try broadband internet.=20