About memory

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 ... of the CPUs. The rest are hardly used. SWAP memory is available but never used (no swapping occurs).   ... all the 320,000 objects,  and sorting them in memory in order to pick the first 50 that will be returned. With the suggested ...

 
release

2.5.1

... Version 2.4.4 Improved memory management when handling very large transactions ( issue #170 ). ... space. Removed a shutdown hook that leads to memory leak ( issue #63 ). Completed missing documentation ...

 
issue

NullPointer when accessing entity field

Hello, following exception occurs when using objectdb: ... database object, but each EntityManager has a separate memory representation of that object, and should not use memory objects that are managed by other  EntityManager instances. ...

 
release

2.3.3

... space. Removed a shutdown hook that leads to memory leak ( issue #63 ). Completed missing documentation ... UPDATE & DELETE queries). Fixed memory leak issues. Fixed server hang and deadlock issues. ...

 
forum_thread

find repeated records by JPQL

Hi, I know a single command in MySQL can find repeated records: Select * from TTT t where id in (select id from TTT s group id having count(id)>1) I dont know how to do this using JPQL, but I use query from 430,000 records and put them into hashmap, finally it cost one hour and failed: ... while trying to load all the entity objects into a memory data structure is expected. You may try splitting the query into ... With 480,026 records, this code cost me 10 minutes and memory crash! So is there existing solutions to clean the repeated ...

 
forum_thread

Java 6/7 Performance Comparison

Hey, I've been using ObjectDB for a small scale home project to gain some familiarity before proposing it in a commercial project at work. What I've noticed though is that when using objectdb in embedded mode based on the console tutorial, there seems to be a bit of a performance gap running the same code between Java 6 & 7 Tracing it through I can see the bottle neck seems to be at the creation of the entity manager and I was wondering if there are any additional configuration options I may have missed while running under java 7. ... again after adjusting the objectdb.conf to grant more memory/threads to applications but have not noticed any differences in ... Attached is the CPU and Memory profile outputs across 2 runs of the test case. I had to change ...

 
release

2.5.0

... Version 2.4.4 Improved memory management when handling very large transactions ( issue #170 ). ... space. Removed a shutdown hook that leads to memory leak ( issue #63 ). Completed missing documentation ...

 
release

2.5.3

... Version 2.4.4 Improved memory management when handling very large transactions ( issue #170 ). ... space. Removed a shutdown hook that leads to memory leak ( issue #63 ). Completed missing documentation ...

 
release

2.5.2

... Version 2.4.4 Improved memory management when handling very large transactions ( issue #170 ). ... space. Removed a shutdown hook that leads to memory leak ( issue #63 ). Completed missing documentation ...

 
release

2.3.4

... space. Removed a shutdown hook that leads to memory leak ( issue #63 ). Completed missing documentation ... UPDATE & DELETE queries). Fixed memory leak issues. Fixed server hang and deadlock issues. ...