On Fri, Jan 19, 2007 at 12:51:36AM +0100, Nemanja Corlija wrote: > On 1/19/07, Nicolas Williams <[EMAIL PROTECTED]> wrote: > >Why don't you use a trigger to duplicate INSERTs into the memory db to > >the disk db? > > > Nicolas, thanks for the idea. Didn't really think of that. > > But in my experience inserting into disk db with a unique index is > very slow when you have millions of rows. I think last time I did that > table had around 6-7 million rows and it took 2 hours or maybe even > more to insert 500.000 rows.
If you kept the rowids in sync in the two DBs then you could keep the updates very fast by not making that column a primary key. Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
