About size

forum_thread

Significant I/O costs during batch update or insert data.

Our application has some complex entities. We do batch update(merge detached entity) every 2 minutes. We find the period significant IO costs these days, and disappeared when turn off the batch updating. 1.ObjectDB is in embedded mode. 2.ObjectDB version is 2.3.7 3.Database file size is nearly 600mb and increasing. ... 2.ObjectDB version is 2.3.7 3.Database file size is nearly 600mb and increasing. ... Maximum file size: 32 MB 0 ...

 
forum_thread

Query by array element

Hello, I have a class as follows: @Entity public class MyEntity {     boolean properties[]= new boolean[1024]; } I would like to query objects with feature '42': select me from MyEntity me where me.properties[42]=true Is it possible? Thank you! ... ( query. getResultList ( ) . size ( ) ) ;   em. close ( ... Maximum file size: 32 MB 0 ...

 
forum_thread

Problem with queries on lists with reverse mapping

Hi, In version 2.4.2, when an object in a list is reversed mapped to the owning object, queries are returning objects of types that were not specified in the query.   In the attached example the last test fails because the query returns both TeamA and TeamB objects where only TeamA was specified in query. If the "team" is omitted from the player and targetEntity = Player.class, mappedBy = "team" are removed from Team the query returns the expected result.   ... ) ; assertEquals ( 1 , q7results. size ( ) ) ; It looks like the result is not ... Maximum file size: 32 MB 0 ...

 
forum_thread

Need disk usage and delete some old files

    Hello , is it possible to get disk usage of database ? If disk usage becomes too high , delete old date files from database. And recalculate disk usage back ?   ... database is a single file you can simply check its size using the length() method. In embedded mode this should be ... Maximum file size: 32 MB 0 ...

 
forum_thread

Unexpected COUNT Results

We are working with objectDB version 2.5.5.b01. (we also tried to use the latest version 2.6.1) We have several issues with queries that can be seen with the attached database and using ObjectDB explorer: 1.       Using ObjectDB explorer... This query returns the list with size  1380. This is expected result If we add COUNT operator: ... Maximum file size: 32 MB 0 ...

 
forum_thread

Entity has be persistended,but query not fetched?

I create a new entity T newT and persistend it,then I create a query "select t from T t" to fetch all T entities.But  then the newT is not contain in the query result. Why? ... " + query. getResultList ( ) . size ( ) ) ;   em. getTransaction ... Maximum file size: 32 MB 0 ...

 
forum_thread

Query results are not up to date for entities, not primitives

When using the CriteriaBuilder to query, the retrieved list are not refreshed according to the latest updates. But, when using the JPQL Query, the list are refreshed. What is the problem? ... - timeout = "0" / > <url - history size = "50" user = "true" password = "true" / > ... / > < / general>   <database> <size initial = "131072kb" resize = "131072kb" page = "2kb" ...

 
forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System ... = "0" /> <url-history size = "50" user = "true" password = "true" /> ... >   <database > <size initial = "1024mb" resize = "256mb" page = "2kb" ... Maximum file size: 32 MB 0 ...

 
forum_thread

Is it possible get the All PrimKeys for a given entity class in the DB?

Hi, I would like to retrieve all the primKeys (user defined) by doing something like: TypedQuery<MyClassPrimKey> query = em.createQuery("SELECT mif.primkey FROM MyClass mif", MyClassPrimKey.class); The only alternative I can think of - would be to store the primkey on the object - but sounds like it is double storage Thanks ... is expected to be minimal, and the database size will not change. ObjectDB Support ObjectDB - ... Maximum file size: 32 MB 0 ...

 
forum_thread

OneToMany and cascade delete problem

Hi, I don't really know if this is a bug or maybe model that I make is bad. I have a problem with with two different classes with OneToMany relation to one, shared class. For example (first class): @Entity public static class Store { @OneToMany(targetEntity = Offer.class, mappedBy = "store") private List<Offer> offers; } second class: ... for this example, but if you look at logs: Store: 4, size: 10 Offer: Offer for product: 94, store: 4 Offer: Offer for product: 54, ... test with enhancement enabled produces: Store: 4, size: 9 Offer: Offer for product: 64, store: 4 Offer: Offer for product: 24, ...