48 | Query filter comparing Dates in query filters comparing this Date field. Could You please clarify why are there zero-size result collections in the first pack of queries and non-zero size results in the second pack ? I ... (); // these queries should find 1 item assertQueryResultSize(0, pm.newQuery |
48 | 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 |
48 | Performance issues on aggregate querywe are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1 ... : when we query objects that have no objects linked into the relationship ObjectNode.childNodes the query takes around 1 second. when we query objects that have typically 30-50 objects linked into |
48 | 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 |
48 | Speed of queries that return many objectsHi, 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<BenchEnt> query = em.createQuery("SELECT a FROM BenchEnt a", BenchEnt.class |
9 | ClassCastException thrown when running count queryHello! Attached you find a full stacktrace. The query was: SELECT COUNT(t) FROM Position t ... for the fields in the query. Log of the query execution using DEBUG logging level. support Support ... and run the query below it will crash with the exception in crash.txt. select p from Position p |
9 | Deleting JPA Entity Objects of that object from the database. DELETE Queries DELETE queries provide an alternative way for removing entity objects from the database. Deleting objects using a DELETE query may be useful especially when many entity objects have to be deleted in one operation. The DELETE Queries in JPA/JPQL in chapter 4 explains how to use JPA DELETE queries. |
9 | Updating JPA Entity Objects support. UPDATE Queries UPDATE queries provide an alternative way of updating entity objects in the database. Modifying objects using an UPDATE query may be useful especially when many entity objects have to be modified in one operation. The UPDATE Queries in JPA/JPQL in chapter 4 explains how to use JPA UPDATE queries. |
9 | Is ObjectDB better than competing object databases? queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries, as part of its support of JPQL (JPA Query Language) and JDOQL (JDO Query Language). ObjectDB is faster than other products. |
9 | 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 |
