6 | Queries are slow on a large databaseHi, I have a 12GB database with 787603 entries. It is much larger than usual and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total ... and the performances are much better. I will try composite index later. However there is one thing I haven't |
6 | Bidirectional OneToMany is slow on updated items that can improve performance dramatically, is to avoid using mapped by collections: @OneToMany(cascade ... are faster than the 1st. If you need to improve performance further, consider replacing the find |
6 | Query becomes slower on moving from ObjectDB 1.x to ObjectDB 2.x, so it should be possible to get at least similar performance for this query with ObjectDB 2.x. Maybe ... that demonstrates this performance problem. Your other question will be moved to a separate forum |
6 | Insert time increases as db grows.? 4410 Arsenii With enhanced classes you may get much better performance. Enhancement is very easy ... after every commit, to avoid further performance loss over time. support Support Well, I'm using Spring Data JPA |
6 | Query for objects persisted within the same transaction/java/jpa/query/setting#Flush_Mode_setFlushMode support Support Thanks, The part about performance in documentation is so true. I think I'll stick with map to check for duplicates, as performance drop is like 20x - just tested. lwalkowski Lukasz Walkowski |
6 | Duplicate a table for this purpose. Use enhanced classes to get best performance in reading and writing the objects. The impact of object instantiation on performance should be minor. support Support |
1 | NullPointerException when using multithreading performance may be improved by: Enhancing the code. Using embedded mode instead of client server ... ! ObjectDB is performing very well now that I have adjusted my executor and allowed for enough time |
1 | Referential Integrity, but even then, it is expected to be disabled by default because reference integrity has a performance ... with the Doctor), avoiding reference integrity checks at runtime improves performance at a minimal risk. support Support |
1 | Threaded Test - Failed to commit transaction: Unexpected internal exception with JDK 1.5 and had the performance problem as you described. The problem is indeed in running ... . support Support Agreed - I've split the entity and performance is much improved and consistent. Thanks |
1 | message: RetrievalTask in logwe faced a poor performance of objectdb last week, during that time frame we have this message in the log: ... [2019-03-01 11:53:40 #5 store] RetrievalTask.reportPrimaryResult0: page#27184134, reader ... . It is possible that the same exception is related to the performance issues and to the writing of that log |
