Home » Search

About size

11-20 of 200Refresh
Issue
24

Bug when using SIZE in combination with date lower parameter

there seems to be a bug if I use the lower date select: SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated < :date This returns a SIZE(j.tags) of 0 Tags, but the only existing ParserJob has 1 Tag. If I run the query: SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated >= :date I
Forum
23

Database(*.odb) file size on disk

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
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
19

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
17

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
17

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

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
14

Database Explorer

, a default viewer (a Tree window by default) is opened with the query results and the size of the result ... on the left side and then use the combo boxes on the right side to choose font face, font size, font
Manual
14

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