About less

forum_thread

500Mb ObjectDb database opening issue

Hi, I have observed that 500 Mb objectDb database opening time is very slow (~3 seconds) for following code m_EntityMgrFactory = Persistence.createEntityManagerFactory( "objectdb:" + aFilename ); m_EntityManager = m_EntityMgrFactory.createEntityManager(); Does exist any way to speed-up open time for big databases? Definitely, it's too long for 500 Mb database! ... results show that opening your specific database takes less than 100 milliseconds (excluding loading of ObjectDB into the JVM, which ...

 
forum_thread

find() cost unreasonable time!

Hi, I make a full binary tree of 4095 node, I check the first 9 node, but the root cost 24 seconds, why? Result: ... is very efficient in retrieving a single entity object but less efficient when you need to retrieve many entity objects (524,290 in your ...

 
forum_thread

Remove not working

Hello! We have a strange problem. ... commonly used these days, including with ObjectDB (maybe less than 5% of the active users), you may find other minor issues (at the ...

 
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 ... when run for the first time. We get results back in less than as second on subsequent executions. Note that we have the following ...

 
forum_thread

Exception on creation when running multithreaded

Hi, I'm trying to test the creation of an object from my datamodel(Organisation) and the creation process includes the creation of an acl for the newly created organisation all in the same transaction. The process is as followed: 1. The organisation gets created 2. The acl is being searched to check if it already exists 3. if it exists it will be updated, otherwise it will be created   ... reproduce it on my test project yet which is a lot less complex than the one I'm testing on but in the meanwhile, here is the ...

 
issue

InternalException - error reading field from "queue" database

I trying to use an objectdb database as a persitent queue but have started getting the following error on the receiver side: ... network but it turns out that rar compresses the file to less than 32MB so I've attached here. Please let me know if theres ...

 
forum_thread

Problem with distinct select, order by and equivalent alias/attribute path

Hi, while working with a (standard-)JPA-query generating framework we run into an exception when ordering the results of some projection when the order by expression is different (though logically equivalent) to the projection expression. Here is the example: ... ORDER BY p . price ObjectDB is less restrictive, and will except the query above. However, in DISTINCT and ...

 
forum_thread

Internal exception when updating date filed (TemporalType.DATE)

Hello! ObjectDB version 2.5.3_02. I get internal exception when commiting update Date field (javax.persistence.TemporalType.DATE). ... The problem does not occur every time, when I create less than 1,000 users. I slightly changed my example to reproduce my ...

 
forum_thread

Entity is not related to ObjectDB, but i get exception from ObjectDB

Here is the description of the problem we are facing:
We have an entity DialogActionNew which previously was located in ObjectDB and recently has been transferred to PostreSQL. We are using ORM Hibernate
When getting this entity from PostgreSQL with the key EntityManager.find(id), we receive another entity - DialogNew, which has an exception: ... and avoid enhancing its super entity class. It is less efficient, but ObjectDB should work also with no enhancement at all, in ...

 
forum_thread

Explorer in 2.3

First, the new Explorer in ObjectDB is fantastic! This is exactly what we've needed - an easy way to do ad-hoc JPQL queries and navigate through the results and even make small changes to primitive data and Strings. After playing with it for a while, here is a list of additional features I'd love to have: 1. Export of selected data: a. Simple - Select a range of cells or a column header and copy text to the clipboard or save to a file (csv, html, etc..). (There appear to be copy menu options, but I cannot get them to work.) ... must be synchronized with code refactoring and this is less error prone. ObjectDB Support ObjectDB ...