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

 
forum_thread

ObjectDB Explorer very slow with remote con

Hi! I started to use ObjectDB Explorer to administrate a remote DB (on a server), but it seems to be very slow. The database is quite empty now, just between 5-20 records / entity, but it's still very very slow. That's the only thing that is slow on my server... How can I speed it up? ... a remote DB (on a server), but it seems to be very slow. The database is quite empty now, just between 5-20 records / entity, but it's still very very slow. That's the only thing that is slow on my server... How can I ...

 
forum_thread

Slow searching with two indexes

I'm running queries on a large database (tens of millions of objects), and I'm running into a performance problem using two indexes.  An entity I'm querying has two indexed fields - one is the primary key (id) and so is different for each object, and the other is an object reference that only has a few tens of different values.   When I query by just the primary key, it's (of course) extremely fast, but when I also query using the other key, queries can take minutes.... candidates for querying the primary key.  This is the slow part.   I'm looking for a way to optimise this querying. ... The second query is slow because of the need to retrieve timeReceived value for a lot of ...

 
forum_thread

Slow performance on Mac

- This code is tested on Windows and Mac. Windows is working great, Mac is very slow (read is 11 seconds on Mac, and 100 milliseconds on Windows). - Application is using Spring Boot console application (for JPA implementation) - MacOS Sierra 10.12.3, Core i7 CPU, 16GB RAM, SSD drive java version "1.8.0_131" Java(TM) SE Runtime Environment (build 1.8.0_131-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, mixed mode)   Running sample jar: ... on Windows and Mac. Windows is working great, Mac is very slow (read is 11 seconds on Mac, and 100 milliseconds on Windows). - ...

 
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?       ... Your test becomes slow as the database is filled. Every task run includes: ...

 
forum_thread

Merge of entity classes with "mapped by" very slow

Hi, I have found a strange behavior when merging entities with "mapped by" set on @OneToMany relation. Even if object is fetched with find on the same transaction, merge is very slow. It's because on merge every single relation marked as LAZY is fetch from database. Attached two examples - one with mapped by, second with adding entities list without "mapped by". The difference is huge event for such small objects - 2ms (without mapped by) vs ~50ms (with mapped by) ... fetched with find on the same transaction, merge is very slow. It's because on merge every single relation marked as LAZY is fetch ...

 
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

Mapped By Fetch is very Slow

Well ! I think i pointed out a HUGE performance issue with mapped-by attribute (yeah again :( ). Here is the test case : 1- Create 100 000 entities with for each 1 entity with @OneToOne(mappedBy attribute) 2- Retrieve only 10 000 for testing 3- Wait ... On my AMD FX 8350, it took 60s Now, go the MyEntity class and remove "mapped-by". You obtain 1 second max of query fetch. #1 2015-06-19 11:05 Well ! I think i pointed out a HUGE performance issue with mapped-by attribute (yeah again :( ). Here is ...

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