About results

forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System ... max-threads = "10" /> <query-cache results = "64mb" programs = "50" /> <extensions ... to complete on average when run for the first time. We get results back in less than as second on subsequent executions. Note that we have ...

 
release

2.7.3

... in handling large objects with long primary keys as query results ( issue #260 ). Fixed detachment of embedded objects to ... Fixed a bug of returning managed hollow objects in query results. Fixed an error message for invalid DELETE query ( issue ...

 
release

2.7.3_01

... in handling large objects with long primary keys as query results ( issue #260 ). Fixed detachment of embedded objects to ... Fixed a bug of returning managed hollow objects in query results. Fixed an error message for invalid DELETE query ( issue ...

 
forum_thread

java.sql.Date equals comparison not working with CriteriaAPI

Hello, Using ODB 2.4.5 and the Criteria API, doing a simple equals comparison with java.sql.Date value doesn't match any results in the database. Our code looks like this: ... comparison with java.sql.Date value doesn't match any results in the database. Our code looks like this: CriteriaBuilder ... a query string and the same data yields in correctly two results. Calling the toString method of the created predicate yields in ...

 
release

2.7.2

... in handling large objects with long primary keys as query results ( issue #260 ). Fixed detachment of embedded objects to ... Fixed a bug of returning managed hollow objects in query results. Fixed an error message for invalid DELETE query ( issue ...

 
forum_thread

Entity name

2. Object creation I created a class named EBResult which looks like this: @Entity(name="RESULT") public class EBResult extends Pojo implements Serializable{..... In ObjectDB-explorer (which is part of ObjectDB library) I expected to see an object named "RESULT" due to class annotation @Entity(name="RESULT"). Instead I see following: #1 2017-02-10 17:28 Hello !! I am new in JPA / ObjectDB development and I have many questions:   ...

 
forum_thread

Beginners questions

Hello !! I am new in JPA / ObjectDB development and I have many questions: 1. If I understood correctly, ObjectDB is an implementation of JPA standard (currently 2.0)? 1.1. Is ObjectDB on the same level like Hibernate with only difference that Hibernate stores the data in a RDBMS and ObjectDB has its own format?   #1 2017-02-10 13:12 Hello !! I am new in JPA / ObjectDB development and I have many questions:   ...

 
api-jdo

addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)

Add a subquery to this query.(Method of javax.jdo.Query)

 
forum_thread

Queries are slow on a large database

Hi, I have a 12GB database with 787603 entries. It is much larger than usual and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total number of entries Get 25 consecutive entries (i.e. 0-25) Get one specific entry On average each query needs 4 to 5 minutes to return a result. I have been adviced to use indexes but they are already used through the JDO Metadata file. For instance I use this class: ... same requested  logTestRunId , then ordering the results may be the problem, since to return the first 25 objects, all the ... Id can be the solution for this specific query, because results can be ordered by the index rather than by accessing the data. If you ...

 
forum_thread

Fantom

  Hi, so far I've been able to get ObjectDb to persist objects from many JVM languages, eg.: Java/Groovy/Scala/Kotlin. However, I can't seem to get Fantom to work. Anyone tried this yet? Dave     ... Running the class results in "ERROR: sys::UnknownSlotErr: OdbTest::OdbTest.main" The ...