About speed
Chapter 6 - Configuration
Explains how to configure and tune ObjectDB, the fast Java object database for JPA/JDO. The ObjectDB configuration file contains one <objectdb> root element with seven subelements: <objectdb > <general > ... </general > <database > ... </database > ...
Entity Management Settings
Explains settings and performance tuning of JPA entities in ObjectDB, the fast Java object database for JPA/JDO. The < entities> configuration element specifies front end settings that are relevant on the client side and in embedded mode. The default configuration file contains the following <entities> element: <entities ...
General Settings and Logging
Describes general configuration and logging of the ObjectDB Java object database for JPA and JDO. the ObjectDB General configuration section. The <general> configuration element specifies ObjectDB settings that are relevant to both the server side and the client side. The default configuration file contains the following <general> element: <general ...
Database Management Settings
Explains settings and performance tuning of the ObjectDB Java object database for JPA/JDO. The <database> configuration element specifies back end (database engine) settings which are relevant on the server side and in embedded mode. The default configuration file contains the following <database> element: ...
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. ... . createEntityManagerFactory ( "$objectdb/db/speed.odb" ) ; EntityManager em = emf. ... per second. Finally, here is the batch insert speed comparison in the JPA benchmark: ... set to objectdb.jar, I see no problem at all, the speed is about 150K/second. Seems like something is not right with ...
Speeding up reporting queries with size() on list
Hi, I'm working on some reporting stuff in our application. One of few different reports should include activity on last modified objects. The query for now looks like this: select date(insp.lastModificationDate), insp.modifiedBy, insp.description.length(), insp.products.size(), insp.picture from Inspiration insp order by date(insp.lastModificationDate) desc insp.description is normal String field in Inspiration entity. insp.products is a list with 0 to 600 objects. Definition: ... runs in 15-30ms each time. My question is - how to speed this type of queries, where you have to count objects on some lists? ...
ObjectDB Object Database Features
ObjectDB provides a rich set of features, many of them as the result of supporting the JPA and JDO APIs.... Performance and Speed ObjectDB is extremely fast - much faster than any other JPA ...
Caching/Paging Questions...
Greetings ObjectDB team, All below questions assume a very large database (~1,000,000,000 objects): Q1: Two queries with a big overlap between their result sets. If I query the first set and hold the results in memory somehow, would that speed up the execution of the second query since many of its result objects already created and reside in memory ?... set and hold the results in memory somehow, would that speed up the execution of the second query since many of its result objects ... paging result sets via setFirstResult and setMaxResult speed up the query execution since there are fewer result objects to bring into ...
Listing large number of complicated objects with paging.
Hi, For last few hours I was working on a problem with bad performance and memory problems with such a simple query: select prod from Product prod order by prod.id ASC Right now I have 55541 'Product' (attached to this post) entities in database and I'm trying to speed listing them with paging. The problem is, that running code that looks like this: ... to this post) entities in database and I'm trying to speed listing them with paging. The problem is, that running code that looks ... to connect to this server. So, how else can I speed up this type of query? Or maybe I just need to add some more heap space ...
Index causes increased memory usage
Hello, ... Hello, In an effort to increase the speed of our queries with our embedded ObjectDB system, we configured our JDO ...
