About size

11-20 of 200Refresh
Forum
23

odb file size doesn't shrink

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

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
Manual
22

Collections in JPQL and Criteria Queries

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 to the number ... ("English", "French"); // SIZE(collection) Expression size = cb.size(languages);  
Manual
18

Shared (L2) Entity Cache

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 cache a positive value
Manual
15

GROUP BY and HAVING clauses

their currency, and for each group returns the currency and the cumulative population size in countries that use ... , for which the cumulative population size and the average population size is then calculated. Any JPQL query
Manual
15

UPDATE SET Queries in JPA/JPQL

size of all the countries by 10%: UPDATE Country SET population = population * 11 / 10 UPDATE ... the population size of countries whose population size that is smaller than a specified limit
Manual
15

UPDATE SET Queries in JPA/JPQL [2011-11-22]

size of all the countries by 10%: UPDATE Country SET population = population * 11 / 10 UPDATE ... the population size of countries whose population size that is smaller than a specified limit
Result
15

ObjectDB Object Database Features [2018-01-27]

can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... and Limitations Database file size up to 128 TB (= 131,072 GB = 134,217,728 MB). Up to 2,147,483,648 ... (LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER OF, SIZE
Result
15

ObjectDB Object Database Features [2018-10-27]

can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... and Limitations Database file size up to 128 TB (= 131,072 GB = 134,217,728 MB). Up to 2,147,483,648 ... (LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER OF, SIZE
Result
15

ObjectDB Object Database Features

can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... file size up to 128 TB (= 131,072 GB = 134,217,728 MB). Up to 2,147,483,648 entity classes ... , SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER OF, SIZE). Java standard methods