About tuning

manual

Setting and Tuning of JPA Queries

Explains various JPA query settings - result range, flush and lock.... Page... interfaces define various setting and tuning methods that may affect query execution if invoked before a query is ...

 
manual

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 > ...

 
manual

JPA / JDO Class Enhancer

The Enhancer is a post compilation tool that improves performance by modifying the byte code of compiled classes after compilation. ObjectDB Enhancer is a post compilation tool that improves performance by modifying the byte code of compiled classes after compilation. Enhancement is mainly for user-defined persistable classes ( entity classes , embeddable classes and mapp ...

 
manual

JPA Query API

Describes the API that JPA provides for running queries against the database.... JPA Criteria API Queries Setting and Tuning of JPA Queries In addition, the syntax of the JPA Query ...

 
manual

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 ...

 
manual

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 ...

 
manual

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: ...

 
forum_thread

Performance tuning, best practices

we have a system where we serve from a host process around 200 clients connected via webSockets (Jetty). The core process is running on a dedicated Windows 2012 server with 16 GByte RAM and 8 processor cores.  What is strange for us is that max 20% of the cpu resources are used and the IO subsystem is at maximum 30% of activity under heavy load but database queries are let's say not at the speed we would expect. We have currently 20.000.000 objects in the database, our configuration settings are: #1 2016-11-15 08:07 we have a system where we serve from a host process around 200 clients connected via webSockets (Jetty). The core ...

 
forum_thread

how to query by properties of onetomany relations? (Error 990)

the following code fails em.createQuery("select f from Foo f where f.bars.name = ?1", Foo.class).setParameter(1, barName) stacktrace: ... More information is provided on the Query Setting and Tuning page. ObjectDB Support ObjectDB - Fast ...

 
forum_thread

Occasionally slow requests in load testing

We are running load testing against objectdb version 2.3.7_18. The performance is generally OK, however there are quite a few "spikes" in the performance where we are getting a lot of very slow response times from the DB, around 10 - 15 seconds. Looking at the DB server process with AppDynamics we can see that most of the requests get stuck in one of 2 places: com.objectdb.o.PGC:w: line number 232 com.objectdb.o.LFL:U: line number 1068 Please see the attached callgraph examples for full stack trace examples. ... is briefly described in the manual  and no other tuning options are currently available. Changing the   resize attribute ...