About slow

release

2.5.1

... in queries. Fixed a possibly very slow query execution when using entity parameters. Fixed issues ...

 
forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System ... ) ; // TODO Remove me for production. Testing slow query   List dtoList = new ArrayList ( ...

 
forum_thread

Selective merge/cascade of detatched entity

I'm having an issue with my application, and I'm hoping you guys will be able to help. Please forgive typos and obvious errors, I'm having to retype from a non-internet connected network. A contrived example is: ... program. It definitely demonstrates activity that is too slow. The problem is with the cascading merge operation that becomes ...

 
release

2.4.7

... in queries. Fixed a possibly very slow query execution when using entity parameters. Fixed issues ...

 
forum_thread

Insertion Speed Rate and Batch Load

1. I got about 10K inserts / second, is it normal? I would expect more than that, like close to 100K/second. I can definitely do 80K inserts/seconds on Oracle with batch insert on table with one primary key. 2. Is batch update/insert operation supported? I attached the files. ... Maybe the transaction is too slow, that cause emf.close() catch a error. The speed is not good. ...

 
release

2.5.0

... in queries. Fixed a possibly very slow query execution when using entity parameters. Fixed issues ...

 
forum_thread

Failover from Master to Slave

Good morning! I am interested in ObjectDB for a client project I am currently working on. In order to evaluate your tool I would like to know if your product has the ability to failover from a Master Database to a Slave Database and then recover back to the master when the master comes back online. I don't see any documentation about automatic failover.   Thanks Rich   ... which is to effectively kill a server that is either slow to respond or not working properly. That would prevent this scenario. ...

 
issue

again merger missing logs + objectdb exception

we are facing similar problems as we had before, in the log we have a lot of entries merger ... missing + an objectdb exception. Some objects in the system behave strange. This is a part of the log: ... [2017-09-26 12:16:14 #1222 store] SectionClassifier: SectionClassifier{238146996->merger[3309]-missing:1} [2017-09-26 12:16:25 #1223 store] SectionClassifier: SectionClassifier{238146996->merger[3309]-missing:1} ... With no ability to reproduce the problem (yet) progress is slow, but we are getting closer and hope to have a solution (at least a ...

 
issue

Use temporary files to enable very large transactions

We have transactions in which many objects are created. These objects are no longer needed in the current transaction after creation. Unfortunately, we will receive an OutOfMemory exception because the objects are kept in the first level cache of ObjectDB. In the forum thread http://www.objectdb.com/database/forum/921 on post #4 you wrote, that ObjectDB should support very large transactions in further version. Can you implement it that ObjectDB used temporary files? ... be used only if there are no other options. It is also slow. A much better solution (faster and with unlimited transaction size) is ...

 
manual

[ODB1] Chapter 7 - JDOQL Queries

Explains how to use JDOQL, the Java/JDO Query Language.... in SQL, queries with unbound variables may become very slow, so caution is needed when using them. 7.5  Import ...