OpenEuphoria

RE: Berkeley DB with Euphoria

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

Robert Craig wrote:
> Andy Serpa writes:
> > Well, 1.2 GB is too big.  It is not the size so much 
> > as the speed as EDS gets slower and slower as it grows...
> 
> 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.
> 

I'd like to get your copy.  Possible?

I speeded up my own copy a little bit (like caching key pointers so when 
it switches tables back & forth it doesn't have to read them in every 
time) but yours sounds like a major improvement.


> But if you are starting at 1.2GB and growing 0.1 GB/month
> I'd be a bit worried about the 4GB limit. Of course
> you could consider creating several separate databases
> of 4Gb or less each.
> 

Well, it holds so many years of data and grows every month, but at the 
end of the year you can dump a years worth of data off the beginning, so 
it doesn't grow forever.

But my intention was certainly not to trash anything.  I *LIKE* EDS, I 
*LIKE* SQLite, but I'd still like to give Berkeley DB a try!  Even an 
improved EDS certainly couldn't compete with optimized C in terms of 
speed (the web site says something about 1000's of inserts a second) and 
Berkeley also has things like transaction support, etc.

Really would love your version of EDS, though, Rob.

-- Andy