ObjectDB Database Search

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

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

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

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

activates the new indexes. The priority attribute specifies the speed of the background index

to speed up the creation of future EntityManager instances. Using an EntityTransaction Operations

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

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

, 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

-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

(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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

. for query execution speed ), we will need to look elsewhere. support Support

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

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

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