Hi, does anyone have experience with database with more than billion records (ie. more than 1000 million records) in one table.
What is the limit of ObjectDB and is the database still fast.
We are planing to do an application which handles document records and there metadata.
Our largest test includes 2,000,000,000 instances of a simple entity class.
ObjectDB is still fast, but obviously slower than when using a small database that can be cached entirely in memory, since I/O operations are slower than RAM access.
See this page for information about ObjectDB limits.
That is great, we dont expect the database to be larger than 300GB. It will fit in system memory.
Is this size of database file supported in-memory on ObjectDB.
We have a server with persistent RAM so there is no problem of data loss.
ObjectDB supports pure memory database since version 2.6.4.
There is no size limit, but it is a new feature, so if you experience issues let us know.