About Index

release

2.2.0

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

 
release

2.2.2

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

Persist error @ManyToMany how to define correct entities relationships

I have Product entities containing a list of Category enties. Each product can have multiple Category but all sue the same limited set of Category entities. There is not changes made to Category from Product. The category ID is taken from the webservice Object ID (unique too). ... are created but category webservice ID are used as index (and they may already exist in objectdb). I will try with merge, this is ...   New try with @Genreated index and @Unique category ID, 1 category entity is created in the table on 2, ...

 
forum_thread

Join performance in Objectdb

select count(e) from Meta e, ImageNet i, Page p where e.idImage=i.id and e.idPage=p.id; So simple a command cause me half an hour and is running now! Each table has about 160K records. What formula can predict the time for such counting? TIA ... Page and Image are not annotated with @Id or @Index . In that case, executing the JOIN may require iteration over 160,000 ... 1, It is supposed that there is an implicit index for the @ID in JPA, right? 2, I add @index to each field of ...

 
forum_thread

Delete me

Why does the below code not enforce unique restrictions?   Person.java ... Unique to an existing database is like adding an index (since  Unique is implemented as an index), and therefore requires index rebuilding  (currently using the ...

 
release

2.2.1

... 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 best to unbind all names?

My JDO application does inserts with binds, and then subsequently does bulk deletes using this code: ... field, which may be set as a primary key or as a unique index. This will also solve the orphan problem.   ... It is true that in ObjectDB 1.x the free edition had no index support. ObjectDB Support ObjectDB - Fast ...

 
forum_thread

Performance question

Hello, suppose you have an entity that holds a reference to another entity which in turn contains e.g. a date field you want to query for. Is there an improvement in performance if I create a "mirror" date field in the original entity, removing the need to traverse through the referenced other entity? So, querying for "all objects with object.otherobject.date > 1.1.1980" is slower than "all objects with object.date > 1.1.1980"? Or doesn't this matter, using proper indexing? Thanks, Benjamin #1 2011-10-20 19:01 Hello, suppose you have an entity that holds a reference to another entity which in turn contains e.g. a ...

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

 
api-jdo

Index.table

Table for the index.(Annotation Element of javax.jdo.annotations.Index)