ObjectDB Database Search

insertions? Question 2 : Why the size of db increased to 16,671,309,824, while the original images ... every 256 images. The database size should be larger than the size of the image files on the file ... The database size should be larger than the size of the image files on the file system, but more than 100

Hi, I was wondering, is it safe to change page size after database is created and filled with data? Should I set page size to the same value as block size on my filesystem? lwalkowski Lukasz Walkowski The page size configuration setting should only affect new created databases

Hi,  we are planning to implement monitoring feature for the increases in database size . I ... read the size of filename directly from application. But in case of client-server use in future ... and it supports getting the file size and the total number of entity objects by queries: try

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression size (   C collection ) Create an expression that tests the size of a collection. Parameters: collection - collection Return: size expression Since: JPA 2.0

JPA Method in jakarta.persistence.criteria.CriteriaBuilder Expression size (    Expression  collection ) Create an expression that tests the size of a collection. Parameters: collection - expression Return: size expression Since: JPA 2.0

Hello, we have questions about the file size of ObjectDB database on disk. Can you tell us something about how the deleting of entities affects the size of *.odb files on disk? -Will the released ... than the initial size . import java.util.ArrayList; import java.util.List; import javax.persistence.Basic

that DB and the size does not decrease.  In fact it keeps growing as records decrease.  ... are persisted. However, the size of the database file is not reduced. So this is a normal behaviour. Currently, the way to reduce the size of a database is to use the Doctor utility, creating a new (smaller

the size or history of recording? Is there any setting in configuration file? Thank you   Below are sizes of our database files: Main database: nef@l1:~/objectdb$ ls -lah db/cloudai/genose.odb -rw-r

Hello, why delete from ... doesnt modify size of odb? Even in in embedded mode, and in server mode i use recovery, not recording mode. mastervoland Vladimir Sadovnikov When objects are deleted from the database their space is marked as unused and becomes available for future objects. The size

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

What’s the max transaction size , or how is it determined? Trianglehead Json Error The main limit is the available memory in the JVM. There is no hard limit. support Support

:    The element The element specifies the database file and page size settings: The initial attribute specifies the initial size of every new database file. The resize attribute specifies the size by which to extend the database file when additional space is needed. Small initial size

if the collection is empty and TRUE otherwise. SIZE The SIZE (collection) function returns the number of elements in a specified collection. For example: SIZE (c.languages)  is evaluated ... ;  Predicate i2 = param. in ("English", "French"); // SIZE (collection) Expression size = cb. size (languages);  

a limit size that is specified by the threshold attribute. The mb and kb suffixes represent megabytes ... . The size attribute specifies the maximum size of this list. This feature can be disabled by specifying 0 as the maximum list size . The user attribute specifies if user names should be saved

class - using annotations. ObjectDB Configuration The shared cache size is specified in the ObjectDB configuration :       The level2 attribute determines the size of the EntityManagerFactory 's shared cache. The default size , 0 , indicates that the cache is disabled. To enable

The following query retrieves only countries with a population size above a population size p ... them to the SELECT clause. For example, the following query retrieves all the countries with population size

three equivalent queries increase the population size of all the countries by 10%: UPDATE Country SET ... query updates the population size of countries whose population size is smaller than a specified

, and for each group returns the currency and the cumulative population size in countries that use ... that pass the FROM/WHERE phase are considered as one group, for which the cumulative population size and the average population size is then calculated. Any JPQL query that contains an aggregate

ObjectDB is highly scalable and can manage efficiently databases in a wide range of sizes , from a few Kilobytes to hundreds of Gigabytes and even Terabytes. ObjectDB can be used in small embedded ... supports: Database file size up to 128 TB (= 131,072 GB = 134,217,728 MB). Up to 2,147,483,648 entity

can manage databases of various sizes efficiently, ranging from kilobytes to terabytes . Platform ... mode. Capabilities and Limitations Database file size up to 128 TB (= 131,072 GB = 134,217,728 MB

with the query results, and the size of the result collection and the query execution time ... on the right side to choose font face, font size , font style, background color and foreground color

duplicate results. Filtering duplicate results might have some effect on performance, depending on the size

. The setMaxResults method is used to specify the result window size . Any result after hitting that specified

, MOD, NEW, NOT, NULL, NULLIF, OBJECT, OF, OR, ORDER, OUTER, POSITION, SELECT, SET, SIZE , SOME, SQRT

expressions  ( isEmpty , isNotEmpty , isMember , isNotMember , size ). Comparison expressions

a sequence and accepts a name, an initial value (the default is 1) and an allocation size (the default

functions - when the return value is numeric, e.g. INDEX, SIZE . as string functions - when the return

;the countries with population size that is smaller than a specified limit: DELETE FROM Country c WHERE c.population

and kilobytes (respectively), can be used in any size value attribute in the configuration file

), regardless of this setting. The level2 attribute specifies the size of the shared level 2 cache

are considered as one group, and COUNT calculates its size ). Criteria Query Paths and Types Paths

, ...). Collection expressions  ( isEmpty , isNotEmpty , isMember , isNotMember , size

The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. ORDER BY Expressions The following query returns names of countries whose population size

. Can easily be embedded in applications of any type and size . Tested with Tomcat, Jetty, GlassFish

the maximum JVM heap size and improve performance by using HotSpot JVM server mode: $ java -server -Xmx512m

Although I read in this post https://www.objectdb.com/forum/2606 that the size of the transaction ... TransactionTooBigException. But what would help us most, would be a way to check the current size of the transaction ... : java.lang.OutOfMemoryError: Requested array size exceeds VM limit at com.objectdb.o.FIW.m(FIW.java

Hello, I have 2 entity types, which I want to query, ParserJob and Tag. Unfortunately there seems to be a bug if I use the lower date select: SELECT j.jobId, SIZE (j.tags) FROM ParserJob j WHERE j ... should return the same results but they do not. The first query returns 1 result and a tags size of 1

" java.lang.OutOfMemoryError: GC overhead limit exceeded GC overhead limit exceeded Database size is only 67MB, heap size is set to 1536MB. Log files are empty. Database uptime was about 3 weeks ... big (import lot of data from other source). I didn't catch the size of record log file. For now I

upload size limit being exceeded before the post attempt.  =(  ) I desire ... with page file size of 64 KB.  Here are relevant objectdb.conf settings: My persisted class, "JdoBlob2 ... ; Then one can navigate to Classes, double click "byte[]" to view its instances, click "Compute retained sizes

; System.out.println("Cache size before commit= " + pm.getManagedObjects(). size ()); pm.currentTransaction().commit(); pm.currentTransaction().begin(); System.out.println("Cache size after commit= " + pm.getManagedObjects(). size ()); pm.evictAll(); System.out.println("Cache size after pm.evict = " + pm

with this database file. Have you set the database page size to 256KB? The maximum supported page size is 64KB, but unfortunately somehow this was not enforced by ObjectDB. This was fixed now ... this error use page size of 64KB or smaller. support Support Ah, OK.  I will do that.   I

drives should also help. support Support Hi, We've run another test today with large initial DB size , to avoid resizing. The initial size was set to 4.5GB. It was running great for 6 hours ... that can cause large file writes? I would estimate the size of actual data in the db file

where the hard drives are also virtualized. From a certain size of the objectdb file (approx. 1.5 GB ... on the size ) not completly loadet in memory and the virtualisation software tries to make ... problem. The ObjectDB is currently a little over 3GB in size , the respective server service is assigned

; entityManager.getTransaction().commit();   Assert.assertEquals(4, parentEntity.getChildren(). size ());   ... (3, parentEntity.getChildren(). size ()); } @Test public void testRemoveVariant2() {   ... ();   Assert.assertEquals(2, parentEntity.getChildren(). size ());   entityManager.refresh

Since: JPA 2.0 Expression size (C collection) Create an expression that tests the size of a collection. Parameters: collection - collection Return: size expression Since: JPA 2.0 Expression size ( Expression  collection) Create an expression that tests the size of a collection. Parameters

results), currently the size of a transaction (i.e. the total size of database pages that have to be replaced) is limited by the JVM heap size . Supporting huge transactions requires some major changes ... situation. For this, we need more information: What is the total size of data in the transaction

. The message size going into the queue is not large - around 4k at most. Each read/write operation ... reader. The msg size being saved should be around 2mb. The server is running with -Xms256m -Xmx256m ... clients loading a 2mb msg - so 24mb raw data size ? (Let me know if I've got this wrong

sizes of caches and how to configure them. Please clarify whether the RAM is released when you close ... sizes to reduce RAM please provide more information about the RAM consumption of relevant ObjectDB ... , even if at some time the GC collects the unused entities. When reading further, the cache size and the number

. size =" + abs . size ( ) + "]" ;          }      ... ;           return "B [id=" + id + ", abs. size =" + abs . size ... .HibernatePersistenceProvider - Found no matching persistence units [A [id=1, abs. size =1]] [B [id=1, abs

varied in size from 1MB but the entity object is simple and looks like: @Entity public class DataHolder ... but with processing and query cache sizes set to 0mb due to issues we've seen in the past with large objects ... , sometimes it seems to run on past 10k persists without problems. I bumped up the object size (int