Re: cursor traverse order of hash based database -
08-01-2006
, 10:03 AM
Hi,
I'm not sure at what are you referring when you are saying "physically
next"? At the way in which the operating system is reading the db from
the disk?
How does your data/keys pairs look like?
When you are retrieving data with DB_NEXT_NODUP, after the cursor will
finish to read all the key/data paires from the current bucket, the
cursor will move the the next bucket of the hash database.
Also, the same thing is valid for filling in records in the database.
If the estimate or fill factor are not set or are set too low, hash
tables will still expand gracefully as keys are entered, although a
slight performance degradation may be noticed.
Related documentation can be found here:
http://www.sleepycat.com/docs/ref/am_conf/h_hash.html
http://www.sleepycat.com/docs/api_c/db_set_h_nelem.html
Regards,
Bogdan Coman, Oracle |