Internal Website Search

1-44 of 44 results

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 ... /400 = 0.35sec.. + some overhead). I was wondering if this kind of speed is "normal", or

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 ... what it is - but my guess it is coming from some ObjectDB low level I/O settings? Any help on how to speed up query by

Speeding up reporting queries with size() on list

is - how to speed this type of queries, where you have to count objects on some lists?   lwalkowski

Insertion Speed Rate and Batch Load

;      Persistence.createEntityManagerFactory("$objectdb/db/ speed .odb");  

Speeding up the creation of Log entity objects related to other objects

In order to speed -up everything I would like to add log entities related to a device without touching (locking) the device entity. How can I do this with ObjectDB using @JoinColumn(name = "device") because I don't have a back reference from log to device! ----- @Entity public class Device

objectdb speed

objectdb speed

Database Management Settings

; priority attribute specifies the speed of the index building background process as a number between

Obtaining a JPA Database Connection

to a remote server) in a connection pool and use them to speed up future EntityManager construction. Using

ObjectDB Object Database Features

features is in progress - see issue tracking (requires login). Performance and Speed ObjectDB is extremely

virtual servers and one file

is fully used, although the database is only 3GB in size. The speed problems also occur only from 3 ... a Megaraid controller with activated cache. I have attached a screenshot of the measured speed ... the cache to 3800MB, adjusted parameter -Xmx8192m to 16384m. But unfortunately no change in speed

Performance problem

separate test environment its speed is very good. We did a performance analysis on our 2 linux ... , it seems that number of query results have large effect on speed , especially if we exceed certain threshold. Regards

ObjectDB Explorer very slow with remote con

, but it's still very very slow. That's the only thing that is slow on my server... How can I speed it up? zmirc Mircea ... . By having just 1 SSH connection to the VPS, it works at an acceptable speed . Sorry and thanks for your reply. zmirc Mircea Chirac

Open several objectdb databases the same time

-server connections. support Support What about database access performance (read/write speed ... didn't face any speed differences between EMBEDDED & SERVER modes, but both methods

Which storage fits best to ObjectDB?

(but still lower) speeds of data transfer to a single SSD, however only when tested on large media files, so in fact it means sequential reads/writes. If it is tested on small files the speed is getting

Best File system for objectdb

Hello , whats the best Filesystem do you recommend for speed for objectdb? As far i know these ; btrfs , extfs4 , extfs3 , zfs , ntfs , fat32 , EXOFS , Lustre   ... compared to other factors (disk speed , cache size, etc.) support Support

Listing large number of complicated objects with paging.

'Product' (attached to this post) entities in database and I'm trying to speed listing ... loopback to connect to this server. So, how else can I speed up this type of query? Or maybe I just

Caching/Paging Questions...

the results in memory somehow, would that speed up the execution of the second query since many ... via setFirstResult and setMaxResult speed up the query execution since there are fewer result objects to bring into

Missing (null) elements in eager loaded references

to speed it up.   Thanks for the help so far, I will get back in contact if I have new

Single Server License and Embedded Mode

, if it is possible.  I would prefer to stick with embedded mode for the speed . Since we only have a single

TimeSeries and ObjectDB

an entity object. This could be efficient it terms of space and retrieval speed but may be more expansive in

Performance of "InsertTest"

You provided the "InsertTest" in the following post, and say "On Intel Core 2 Quad Q6600 (and enhancement) it persists 340,000 objects per second". Insertion Speed Rate and Batch Load Now, ten years later, I run it on Intel Core i5-5300U (2.3Ghz) with 8GB memory, output is 45000 per second

Multithreading Test and Deadlock

it. Regarding multithreading speed - currently in ObjectDB embedded mode multithreading improves performance

Bidirectional OneToMany is slow on updated items

the javaagent (which you can see in the contained eclipse launch configuration) Is there any way to speed

How to check if an entity exists in a Database without loading it?

Hi, I am trying to speed up some code - where i check if an entity exists in order to make a decision. In Java - It looks like this (pk - is the primary key of the entity): MyClass find = em.find(MyClass.class, pk); boolean exists = find != null; Is there a way to check the existence

Strange behaviour with ORDER BY and IN

Hi, after trying out objectdb for a while now and being quite impressed by its speed and overall performance I noticed a strange behaviour where an ORDER BY - directive isn't executed as it should be (and usually is, except in this special combination-case). Ordering seems to be ignored

500Mb ObjectDb database opening issue

to speed -up open time for big databases? Definitely, it's too long for 500 Mb database! We gonna

Warmup ( preLoad all table rows into memory )

Hi , I have 3 questions for objectdb : 1-) How can i preload all table rows into memory in objectdb ? So i can query fast. I have seen @Cacheable annotation. But i need warmup table to memory when my software boots up.   2-) Also for speed up I am inserting a message into table

Index causes increased memory usage

Hello, In an effort to increase the speed of our queries with our embedded ObjectDB system, we configured our JDO file that defines our persistable objects with some unique String indices.  While this improved query performance considerably, we have noted that our database application

Slow searching with two indexes

by id desc  With the query limited to (say) 10 results. Is there any obvious way to speed

Should I use ObjectDB and JDO?

lead me to believe it might be faster than JPA... ObjectDB has the same speed whether you use JPA

Performance tuning, best practices

at the speed we would expect. We have currently 20.000.000 objects in the database, our configuration

ObjectDB's Database Doctor Incorrect Error Report

too much about the speed and I/O operations. For sure, it will not make your application 4 times slower

Compress ODB file with XML content

, because is it is designed for speed and not for minimum storage space, but compression ratio of 1:50 does look extreme

Query perfromance problem

perfectly well. The difference in speed is really huge. Thanks for the fix. lwalkowski Lukasz Walkowski

ObjectDB Website and Yahoo Mail

. We will check what can be done with Yahoo, as well as with the occasional website speed issues. Thank

In memory processing for ObjectDB

Hi there ! We are building a platform for trades processing where we want to keep our processing speeds very high. We like ObjectDb because its simplicity and the performance benchmarks, but to take it to next level really we wanted to check whether is there any In memory mode available

Performance with large databases

faster than fetching by an indexed field, or should these be about the same speed ? sjzlondon Steve Zara

Index on a low cardinality column

" If many of the values in the field are the same, the index might not significantly speed up queries." "An index on the gender column likely would  not  help because there's no value in an index on a low cardinality column. Meaning, there's not enough variety in the values

Merge of entity classes with "mapped by" very slow

it with the new build.   support Support Thanks for new build. Fix is working correctly. The speed

Left join fetch behaviour doesn't retrieve children?

. support Support Well, seems to be ok support :) Thx for your work and your speed to fix it. But i'm

cannot delete objects after crash (see issue 2283)

performance after the configuration change and report as it may have significant effect on speed in ... Zwicker File sync is a slow operation so this is expected. Although we cannot improve the speed ... improvements: Improving the speed of the sync mode by delaying returning from commit, gathering

Best practise loading big data

speeds up the application. At start of reading, the DB can deliver about 1000 values within 150ms ... speeds up the application. As you wrote, using enhanced classes usually improves performance

Use temporary files to enable very large transactions

which this data is written to a temporary file. Even without speed optimizations, but with priority

500Mb ObjectDb database opening issue

to speed -up open time for big databases? Definitely, it's too long for 500 Mb database! INFO