About result

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 ... hope to receive your recommendation on how to improve this result with this post.   Test System We are ... , r . channelNumber DESC We limit the result to 50 records. Basically we wish to get the last 50 records ...

 
release

2.7.3

... in queries. Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a ... ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to return ...

 
release

2.7.3_01

... in queries. Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a ... ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to return ...

 
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: ... ) ; System. out . println ( "Result Size: " + resultList. size ( ) ) ; ... SELECT $1 FROM MyDateEntity $1 WHERE $1.date=:$$cmlp1 Result Size: 1 The Predicate's toString is irrelevant. As can ...

 
release

2.7.2

... in queries. Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a ... ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to return ...

 
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: ... 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 ...

 
api-jdo

setRange(fromInclToExcl)

Set the range of results to return.(Method of javax.jdo.Query)

 
api-jdo

setRange(fromIncl, toExcl)

Set the range of results to return.(Method of javax.jdo.Query)

 
forum_thread

Does aggregate function "greatest" work on entity objects?

do not come to the function "compareTo" @Entity public class ChatHistoryItem extends AbstractObject implements Comparable {     private static final long serialVersionUID = 1L; ... this.toString() + " compareTo " + t.toString() + " result = " + int result = ( ( int ) ( this . ... this.toString() + " compareTo " + t.toString() + " result = " + result); return result ; }   ...

 
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     ... { Str ? street } Result Groovy version works fine, using the ObjectDb ObjectExplorer ...