About performance

release

2.2.5

... in criteria queries . Improved Explorer performance by disabling EAGER fetch. Fixed critical bugs in ... such as List<String> ). Improved performance of eager fetch in queries. Added Maven build ...

 
forum_thread

More Efficient Primary Keys

Can you give us a recommendation as we can represent the Key (UUID) most efficient? Both in terms of memory usage of the database files, memory usage of the JVM and efficiency for queries. We already need the key before the entities are persisted so that we can build even references. ... you recommend something else? Finally, how much performance improvement would bring a switch to a single long? ... It is unclear if a composite of two longs can produce any performance gain over a single string. ObjectDB ...

 
forum_thread

Bidirectional OneToMany is slow on updated items

Hello, I have a problem with the following situation. I insert persons with addresses. In the first run, they are all new with a new address. It runs fast. In the second run, the persons are all loaded and got a second address. This seams to be much slower. The Entities are all enhanced by the javaagent (which you can see in the contained eclipse launch configuration) Is there any way to speed it up?       ... is not empty. A simple action that can improve performance dramatically, is to avoid using mapped by collections: @ ... are faster than the 1st. If you need to improve performance further, consider replacing the find calls of Address and ...

 
forum_thread

Query for objects persisted within the same transaction

I have a question concerning reading uncommited entities with query, within active transaction. For example, I read data from file. Each line contains value of one of entity's attributes but those values are not unique, so it's possible to have a multiple instances of the same entity. To eliminate duplicates, after reading every line I first check using a query, if an entity with that attribute value already exists. If no - I create one and persist it.... 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. ...

 
forum_thread

Insert time increases as db grows.

Hello, ... With enhanced classes you may get much better performance. Enhancement is very easy. For example, you can apply ... EntityManager after every commit , to avoid further performance loss over time. ObjectDB Support ...

 
forum_thread

Internationalization

What would be a good way to implement internationalization with ObjectDB? Let's say we do have a product catalog and we need to provide category and product data internationally. With a relational database we most probably would have two tables, one for locale neutral information, i.e. Product with fields SKU, price, etc. and another one for locale information only, i.e. ProductLocale with fields name, description, etc. ... annotation, but how would this impact the performance, let's say when there are millions of products each with ... long HTML code, wouldn't that severely impact the performance? What would you suggest to do instead? Thanks a lot ...

 
forum_thread

Query becomes slower on moving from ObjectDB 1.x to ObjectDB 2.x

Hi, I upgraded the odb file using converter.jar which is having 15943 entry. Previously, with object 1.x, the same query was getting executed within an seconds and now the same is taking around 40 seconds in object db 2.x I have build the query using the follwoing Query query = persistanceManager.newQuery("LogEntryAttrebuteImpl.calss", "typeIndexes.contains(this.type) && logEntryIdList.contains(this.logEntryId)"); ... 1.x, so it should be possible to get at least similar performance for this query with ObjectDB 2.x. Maybe an index is ... database and a simple test program that demonstrates this performance problem. Your other question will be moved to a separate ...

 
forum_thread

IMK Stall with certain query

Hello, I am experiencing constant IMK Stall notifications from Java when using certain query: 2015-09-01 16:53:15.785 java[3678:5217999] IMK Stall detected, *please Report* your user scenario in <rdar://problem/16792073> - (imkxpc_deadKeyStateWithReply:) block performed very slowly (4.63 secs) i am sure it is linked with objectdb as these are thrown each time one particular query is used: ... buyerId (if not the PK) and buyerName may improve performance.   ObjectDB Support ...

 
release

2.2.4

... in criteria queries . Improved Explorer performance by disabling EAGER fetch. Fixed critical bugs in ... such as List<String> ). Improved performance of eager fetch in queries. Added Maven build ...

 
forum_thread

High availability and other pratical questions

Hi,   I've just started developing a mobile app which will use a server side, hopefully handling a lot of processing and traffic. I was inteding to use TomEE+ with built-in OpenJPA and Postgres DB, initially on one master server but as it grows more master servers will be set (in different geo locations/data centers) using some data sync mechanism between them.   Now that i've met ObjectDB I want to check the option using it instead of postgres so I have few questions regarding it: ... As the embedded DB seems to be with superior performance would you recommend using it with TomEE+ instead of creating a 2 ... embedding ObjectDB in the main Tomcat server will improve performance. You should be able to access embedded ObjectDB from other Tomcat ...