About query

161-170 of 200Refresh
Forum
21

possible index required for improving query performance

; } With the following query: TypedQuery query = em().createQuery( "SELECT r.party FROM Relationship r ... =RelationshipType."+type.toString(), BaseObject.class); query.setParameter("otherParty_id", otherParty); query.setParameter("pclass", partyClass); We have noticed that this query slows down in
Manual
21

Index Definition

Querying without indexes requires iteration over entity objects in the database one by ... the iteration can be avoided and complex queries over millions of objects can be executed quickly ... ; : } Indexes in Queries ObjectDB manages a BTree for every index. A BTree is an ordered map data structure
Issue
21

ClassCastException thrown when running count query

Hello! Attached you find a full stacktrace. The query was: SELECT COUNT(t) FROM Position t ... the query. Log of the query execution using DEBUG logging level. Hello again! I had the same issue ... for you to reproduce the crash. If you open the attached db with the explorer and run the query below it will crash
Forum
21

JPA query of a Set of terms

Hi, Is it possible to write a JPA query to select objects that contain a collection of elements ... WHERE si.term ????",Page.class); I want the query to give me all Pages that match all of the search terms ... that are already persisted. TypedQuery query = em.createQuery( "SELECT DISTINCT si.page FROM SearchIndex si
Issue
21

Large query parameter - out of memory

as it goes. It then loops through the data from the file and queries for the entity id based ... this should be sufficient as I only create/read one item of data at a time and am only querying for the id. After about 300 queries the test throws an out of memory exception so I assume the query data is being held
Forum
21

Optimization of Map Queries

.get(..) result(s) once to not query the map again and again for each test in my query? 2) Is there anything I could do for shortening the query string? I guess there's no such thing as a "temporary" variable for being used in the query.. I am creating the query using criteriabuilder, then I am converting
Forum
21

Performance issues on aggregate query

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1 ... valid;   No the problem is the following: when we query objects that have no objects linked into the relationship ObjectNode.childNodes the query takes around 1 second. when we query objects
Forum
21

Query becomes slower on moving from ObjectDB 1.x to ObjectDB 2.x

, with object 1.x, the same query was getting executed within an seconds and now the same is taking around 40 seconds in object db 2.x I have build the query using the follwoing Query query = persistanceManager ... (this.logEntryId)"); query.declareParameters("java.util.List typeIndexes,java.util.List
Forum
21

Speed of queries that return many objects

Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java ... - according to blackMagicTest app for mac) - so I was expecting the query to take less than one sec (146 ... ();             TypedQuery query = em.createQuery("SELECT a FROM BenchEnt a", BenchEnt.class
Issue
21

unclear syntax for update query

. Query Update Action Set transferred = 0 where a.objectsInCharge.nodePath like "/(PR)W4455NS01%" and a.objectsInCharge.nodePath like "%MARAS%" results in Query Execution Error ===================== Unexpected query token 'a' Update Action Set transferred = 0