About slow

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

 
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. ... 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 ... of queries and the performance is OK in some cases and is slow in others. Also, the slow response times occur in wide variety of ...

 
issue

Out of Memory - Slow leak?

This is a continutaion of Issue 61 - unfortunately it doesnt seem that the fix in 2.2.9_03 has fixed the problem. The scenario is still the same: I have two "producer" processes which insert messages into an objectdb "queue" database running with an objectdb server process. I have one "consumer" process which reads messages from the queue database and inserts these into an embedded "normal" objectdb database. This is the process which has generated the OOM exception. Bug Version: 2.2.9 Priority: Normal Status: Fixed Replies: 13 Type:  Bug ...

 
forum_thread

slow performance for a complex query

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE ((UPPER($1.cdiId) LIKE 'THREAD14%') AND ((($1.parentOrgId='news') OR (($1.parentOrgId=$2.organisationId) AND ($2.parentOrgId='news'))) OR ((($1.parentOrgId=$3.organisationId) AND ($3.parentOrgId=$2.organisationId)) AND ($2.parentOrgId='news')))) I've also tried running the CDI query first and passing the results into the organisation query as follows: #1 2012-02-16 09:16 Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINC ...

 
forum_thread

possible index required for improving query performance

Hi,   I have the following entity class:   @Entity @Table @Indices({ @Index(members={"relationshipType", "party"}), @Index(members={"relationshipType", "otherParty"}),     @Index(members={"relationshipType"}) }) @XmlRootElement public class Relationship implements Comparable<Relationship> { ... is not indexed, would that be the cause for the slow query? Is there any other index that should be added to make this ...

 
forum_thread

What algorithm in find()

I test the time cost for find(), obtain a linear complexity with the following codes: ... 2011-05-25 00:04 Slow commit might be the result of not using enhancement and not ...

 
issue

Database File Encryption

ObjectDB supports encryption of client-server communication over the network using SSL. Encryption of data in database files is less commonly used, since it slows the database, and when necessary, external encryption is possible (e.g. at the operating system level). Still, this might be useful for some applications. Feature Request Version: Priority: Normal Status: Active Replies: 1 Type:  Feature Request ...

 
forum_thread

Storing Images and Object Pooling

Hello we have heard your product and we will plan to use your product on image database. Is it good to use ObjectDB as image database? Image database just screenshots of desktops.   2- ) On JPA as we know getting Result list returns ArrayList         List<SomeClass> xxx = query.getResultList(); #1 2012-03-15 19:57 Hello we have heard your product and we will plan to use your product on image database. Is it good to use Ob ...

 
forum_thread

To open source, or not to open source

Hi, We are currently using db4o with a commercial licence, but finds it very frustrating after they have been taken over by Versant. The development of db4o is going very slow and major bugfixes are not been backported to stable releases, but only put into bleeding edge branches.   Therefore we do the bugfix backporting ourself. This would not have be possible if db4o was close source.  ... over by Versant. The development of db4o is going very slow and major bugfixes are not been backported to stable releases, but only ...

 
page

ObjectDB - Object Database for Java (JPA/JDO)

Fast Object Database for Java with JPA 2 and JDO 2 support.... system (RDBMS) to store and retrieve Java objects requires slow conversions between graphs of Java objects and flat database table rows. ...