OpenEuphoria

RE: Speed of EDS (was Berkeley DB with Euphoria)

• Posted by Andy Serpa <renegade at earthling.net> Sep 30, 2002
• 413 views

Matthew Lewis wrote:
> 
> > From: Robert Craig [mailto:rds at RapidEuphoria.com]
> 
> > I recently speeded up my copy of EDS.
> > It reads records twice as fast as before, and it
> > inserts and deletes into huge (100,000 record)
> > databases 3 times as fast. Even the released
> > EDS can insert/delete many times per second
> > on huge databases on a slow machine. 
> > If you acquire new records via a human entering 
> > data into a GUI, you'll never notice the time.
> 
> Ooh, ooh!  When can we see it?!
> 

Actually, I've been meaning to ask --

When working with very large EDS databases, inserts get slower and 
slower, but actually what I'm doing much of the time is:

-- checking to see if the key already exists
-- if not, do the insert
-- if so, grab the current record, *append* to it (making it bigger), 
and replacing it.

Is it possible there would actually be less overhead in the second case 
if after grabbing an existing record and adding to it, instead of doing 
a replace I deleted the original record and then did an insert?

In other words, how expensive is doing a replace on the value?