OpenEuphoria

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

• Posted by Kat <kat at kogeijin.com> Sep 30, 2002
• 440 views

On 30 Sep 2002, at 9:21, Matthew Lewis wrote:
 
> Based on looking at the code in EDS, it looks like you're better off doing a
> replace than a delete and insert.  The delete and insert method has to do two
> updates to the key pointers, update the number of records, etc, while a
> replace
> avoids all this.  Also, if you can keep the data the same size, EDS will reuse
> the same location for the data, rather than freeing and allocating new space. 
> It looks like it has to be within 8 bytes of the original (from
> db_replace_data):
> 
>     if new_size <= old_size and
>        new_size >= old_size - 8 then
>     -- keep the same data block

Does this mean if you have large data, which continually shrinks by 7 bytes 
over time, you will eventually end up never shrinking the database, and 
haveing the original size totally consumed by the padding?

Kat