Sunday, October 25, 2009

NeoDatis Benchmark on Android

After doing a lot of different testing and trying a lot of different settings I finally decided to do some testing. I had some heap size memory when doing the complete TestIndex test with all of the 10000 records, NeoDatis like to store all of entries in it's internal cache, so I settled with 1000 for now, until I can figure out a way to get around the memory related issues.



Here are the result table:

Perst
SQLite
DB4O
BerkeleyDB
NeoDatis
Insert
1159
6892
4168
4619
25022
Search
599
9481
18261
3405
18325
Iterate
120
290
4392
2889
11126
Delete
1659
6315
7084
5565
10156
It should be noted that the NeoDatis team releases new versions often, so if you have some problem, it might be fixed in a new version.

8 comments:

  1. Hi.

    Since you're investing time in benchmarking embedded DBs it would be nice if you could turn this into an open source project that could serve a a standard benchmark (of course, this is just a start but it could be improved to cover more advanced cases). Something like PolePosition for Java databases (http://polepos.sourceforge.net) but in the embedded persistence space.
    And I say open source because in this way vendors and users can help improve the benchmark.

    Best!

    ReplyDelete
  2. Thanks for the comment, will do, just got to find a good place to put it, any recommendations?

    ReplyDelete
  3. So what's the advantage of using this over the built in SQLite ?

    ReplyDelete
  4. Well in my opinion the greatest advantage to use an object oriented database management system is; that that you can think objects and Java all the way and not think about converting the result back to Java objects again from the result set. In addition to this there is also some performance increase, especially when dealing with large datasets, that somewhat comes better in a full scale test like this one: http://tordtech.blogspot.com/2009/09/testindex-
    on-android-developer.html

    Tord

    ReplyDelete
  5. Hi Tord,

    Any update on open sourcing your embedded db benchmark? Googlecode would be a good place for it.

    ReplyDelete
  6. Well, I am not aware of this topic.. I need to spend more time on this.. I love learning new thing and hope to see some articles similar to this. Thanks for sharing the information with us.

    ReplyDelete
  7. I like your blog narration.Definitely your post will help you to achieve the goal.This is one of the challenging post.

    ReplyDelete