I have been playing with the Berkeley DB .Net code. I need to implement a high speed "database" to manage users of a SOA. I'm not necessarily understanding the model of the Berkeley DB. Once the records have been put into the db, is the only way to retrieve a given record is to iterate through the whole set until the appropriate record is found? Doing this, I found that for a database of 5000 records, it takes an average of .083 seconds to find one specific record. Does this performance sound reasonable? Is there a better way to pull the data back from the db than walking the records?
Thanks kindly for any help/guidance.
Leland
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You should have some Berkeley DB knowledge before using the .NET interface.
But to answer your question: Retrieving a record by key is what BDB is all about.
Iterating is not the way ...
One of the two demo apps should have code that retrieves by key.
Just have a look at them.
Karl
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been playing with the Berkeley DB .Net code. I need to implement a high speed "database" to manage users of a SOA. I'm not necessarily understanding the model of the Berkeley DB. Once the records have been put into the db, is the only way to retrieve a given record is to iterate through the whole set until the appropriate record is found? Doing this, I found that for a database of 5000 records, it takes an average of .083 seconds to find one specific record. Does this performance sound reasonable? Is there a better way to pull the data back from the db than walking the records?
Thanks kindly for any help/guidance.
Leland
You should have some Berkeley DB knowledge before using the .NET interface.
But to answer your question: Retrieving a record by key is what BDB is all about.
Iterating is not the way ...
One of the two demo apps should have code that retrieves by key.
Just have a look at them.
Karl