> I wonder if it's reasonable to have many cursors open at the
> same time (hundreds). I understand that they are updated when the index
> is, but I'm not able to guess what is the overhead.
It's not unreasonable, but it's going to tie down a lot of the tree.
Each cursor locks a page in the tree, so depending on your locking
and transactional model, you can end up with lots of threads blocked
because they can't acquire locks on those pages.
Regards,
--keith
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Keith Bostic
Sleepycat Software Inc. [EMAIL PROTECTED]
394 E. Riding Dr. +1-978-287-4781
Carlisle, MA 01741-1601 http://www.sleepycat.com
------------------------------------
To unsubscribe from the htdig3-dev mailing list, send a message to
[EMAIL PROTECTED] containing the single word "unsubscribe" in
the SUBJECT of the message.
