Message-ID: <003c01be7469$23fb6a60$8355e5ce@base2inc.com>
Reply-To: "Frank Morton" <fmorton@base2inc.com>
From: "Frank Morton" <fmorton@base2inc.com>
To: <pgsql-interfaces@postgreSQL.org>
Subject: Other JDBC Performance Question
Date: Mon, 22 Mar 1999 08:37:33 -0500

I am using JDBC quite happily and thank you Peter.

I have a case where the database is pretty small and
the quickest response possible is more important
than usual. The whole database is about 2mb or
so with lots of different record key combinations.
I notice that, even using psql, that each time I do
a query, even the same query, the disk is accessed.

What I would really like is to somehow force the
database to be RAM resident, but still access it
using SQL. I am about to write some code to
load the whole thing up into RAM and accessing
it some special way without SQL, but it really
isn't what I want to do.

Is there any way to force the database to be RAM
resident? Either with this package or something
else?

I'd appreciate any feedback on how to very quickly
access small databases using SQL.

Thanks.


_________________________________
Frank Morton (fmorton@base2inc.com)
Voice: (317) 876-3355
FAX: (317) 876-3398
Home: (317) 574-0815