About index

forum_thread

Query perfromance problem

Hi, I was playing with paging and sorting recently and after trying few different aproaches got some strange behavior from ODB. First of all, I will show you results from page rendering times, but trust me - when debugging application, getting data from ODB takes a long time in one case. Anyway, one of my methods in DAO looks like this: ... ms Refreshing this page with any other column for index with @Index set on it, lowers this time do 1-3 secodns. 2011-03-11 13:08:30.897 ...

 
release

2.2.5

... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ... Fixed a query execution bug when index with null keys is used. Fixed a bug in tracking field ...

 
forum_thread

How the sort order (in queries) works for non english letters?

We are considering using ObjectDB in  project where target audience are czech speaking people (we are Czech company). How the sort order works for international (for us 'czech') letters? Does the ordering respects the national requirements? Thank you for clarification ... ... nice if one could just specify they locale as part of the index definition or the ORDER BY clause, so the sort uses the correct collation ... you for this useful link. It makes sense to add index definition support to JPA and include also support of different types of ...

 
issue

java.lang.ClassCastException: com.objectdb.o.SCU cannot be cast to com.objectdb.o.PRU

Error in production urgent [2017-05-19 13:34:09 #14 server] ... There is a corruption into index when I tried to obtain an object that non exist into database. This was ... but if you have more information about the cause of the index corruption we will be happy to explore this issue further, ...

 
api-jdo

Indices.value

The indices(Annotation Element of javax.jdo.annotations.Indices)

 
release

2.2.4

... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ... Fixed a query execution bug when index with null keys is used. Fixed a bug in tracking field ...

 
forum_thread

@Unique added afterward is not taken into account

Hello, ... Unique is implemented as an index, and adding an index on existing data requires rebuilding the database by using the Doctor ...

 
release

2.2.3

... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ... Fixed a query execution bug when index with null keys is used. Fixed a bug in tracking field ...

 
forum_thread

Performance with large databases

When populating a large database (10s of GBs) performance drops suddenly at a certain time whenever I run the populating application.  Is there typically a database size when indexes can no longer be held fully in memory or some such issue?  The method calls that suddenly start to take the most time are those that retrieve data from the store. #1 2013-06-03 00:58 When populating a large database (10s of GBs) performance drops suddenly at a certain time whenever I run the pop ...

 
page

What is new in ObjectDB 2.0?

... IDs (primary key) and sequences. Support of unlimited index keys size. SQL like queries ("select from ... where ..."). Real ...