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
22

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
Result
15

ObjectDB Object Database Features

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

WHERE clause (JPQL / Criteria API)

The following query retrieves only countries with population size that exceeds a specified limit ... all the countries with population size that exceeds a specified limit and also have an official
FAQ
12

Is ObjectDB scalable? What are its limitation?

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