From: Jeremy Hinegardner <jeremy@...>
Date: 2008-07-28T16:10:52+09:00
Subject: Re: Faster Marshaling?

On Sun, Jul 27, 2008 at 11:32:35PM +0900, James Gray wrote:
> On Jul 27, 2008, at 12:33 AM, Greg Willits wrote:
>
>> So, yeah, maybe that or even sqlite might be suitable if the RAM thing
>> just gets too obnoxious to solve.
>
> I would be shocked if SQLite can't be made to solve the problem well with 
> the right planning.  That little database is always surprising me.  Don't 
> forget to look into the following two features as it sounds like they may 
> be helpful in this case:
>
> * In memory databases
> * Attaching multiple SQLite files to perform queries across them

Yup, SQLite is a lovely piece of work.  If you go that route, you might give
Amalgalite a try, it embeds sqlite3 inside a ruby extension using the SQLite
amalgamation source.  I'd love to see if it can stand up to the demands of your
system.

enjoy,

-jeremy

-- 
========================================================================
 Jeremy Hinegardner                              jeremy@hinegardner.org