From: ara.t.howard@...
Date: 2006-08-10T00:15:59+09:00
Subject: Re: Looking for a Fast Persistent Store

On Thu, 10 Aug 2006, Bob Hutchison wrote:

> The thing that makes me nervous is that I can do what I need with just two
> tables. One that has (key, value-kind, value), and another that has
> (index-name, index-value, key, value-kind). Each column is a String. The
> vast majority of queries would be based on key and value-kind on the first
> table.  The remaining queries would be a select/join kind of thing. And I
> can very easily jam the key and value-kind into the same field (but that
> would be an optimisation that may not be necessary). The trouble is that the
> first table might get to be very very large. I don't know how SQLite behaves
> with a single huge table. I suppose I'm going to have to find out.

please post a summary of your findings when you run your tests - i'd be
interested to read them.

cheers.

-a
-- 
to foster inner awareness, introspection, and reasoning is more efficient than
meditation and prayer.
- h.h. the 14th dali lama