About speed

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

Database Management Settings

Explains settings and performance tuning of the ObjectDB Java object database for JPA/JDO.... The  priority attribute specifies the speed of the index building background process as a number between 10 and 70, ...

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

 
forum_thread

Speed of queries that return many objects

Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java) takes about 10sec. I am using a recent MacBook (SSD blabla - disk I/O speed is about 400MB/sec - according to blackMagicTest app for mac) - so I was expecting the query to take less than one sec (146/400 = 0.35sec.. + some overhead). I was wondering if this kind of speed is "normal", or if this is something I should investigate. Thanks EKK ... I am using a recent MacBook (SSD blabla - disk I/O speed is about 400MB/sec - according to blackMagicTest app for mac) - so I was ... + some overhead). I was wondering if this kind of speed is "normal", or if this is something I should investigate. So I ...

 
forum_thread

Several parallel threads to speed up query on one DB

Hi, I have an application: producer (from a DB) to a consumer. The current bottleneck is the producer from DB (based on a query) and I would like to speed it up. I have tried using several entity managers (same DB instance) to benefit from the parallelisation - but it looks like I don't get much benefit from doing that.  ... producer from DB (based on a query) and I would like to speed it up. I have tried using several entity managers (same DB ... low level I/O settings? Any help on how to speed up query by doing parallelization would be appreciated - or best ...

 
forum_thread

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

 
forum_thread

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

 
page

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

 
forum_thread

Which storage fits best to ObjectDB?

Hi, we are just about to put together a new server for our applications using ObjectDB (v 2.6). We have a dilemma about the storage holding the ObjectDB files: if to invest in a mirrored RAID of SSDs which is clearly the ultimate solution but it quite pricey, or to choose a RAID5/6 of 7200 RPM HDDs. ... reads/writes. If it is tested on small files the speed is getting considerably worse. Our DB files range from 700MB to ...