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
Message-ID: <003c01be7469$23fb6a60$8355e5ce@base2inc.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: fmorton@base2inc.com
Subject: Re: Other JDBC Performance Question
In-Reply-To: <003c01be7469$23fb6a60$8355e5ce@base2inc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox