About slow

release

2.5.1

... 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. ...

 
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.5.0

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

 
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 ...

 
forum_thread

Join query problem with new statetment

Hi, I'm trying to implement some reporting logic in my application and got nasty exception when using query with join. The query code is: ... are returned and everything works fine, but is quite slow - that is expected, because of some high number of objects to download. ...

 
release

2.4.7

... 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. ...

 
release

2.4.6

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