About Index

release

2.6.2

... using external classes. Fixed Doctor's index rebuilding to use NULL values for missing values of new fields. ... a bug in retrieving primary key fields in queries (on index merging). Fixed a bug in using a collection field index in ...

 
release

2.5.6

... using external classes. Fixed Doctor's index rebuilding to use NULL values for missing values of new fields. ... a bug in retrieving primary key fields in queries (on index merging). Fixed a bug in using a collection field index in ...

 
release

2.5.4

... using external classes. Fixed Doctor's index rebuilding to use NULL values for missing values of new fields. ... a bug in retrieving primary key fields in queries (on index merging). Fixed a bug in using a collection field index in ...

 
forum_thread

Listing large number of complicated objects with paging.

Hi, For last few hours I was working on a problem with bad performance and memory problems with such a simple query: select prod from Product prod order by prod.id ASC Right now I have 55541 'Product' (attached to this post) entities in database and I'm trying to speed listing them with paging. The problem is, that running code that looks like this: ... <orderPlan plan="sort(fetch(index(-279[all])))" eval="9.3782" var="1" prm="0" reg="0" ... <fatchPlan plan="fetch(index(-279[all]))" eval="7.4751" var="1" prm="0" ... <btreePlan plan="index(-279[all])" eval="6.174" var="1" prm="0" reg="0" variable="prod" ... <orderPlan plan="sort(index(-279[all]))" eval="8.0771" var="1" prm="0" reg="0" ...

 
release

2.5.3

... using external classes. Fixed Doctor's index rebuilding to use NULL values for missing values of new fields. ... a bug in retrieving primary key fields in queries (on index merging). Fixed a bug in using a collection field index in ...

 
release

2.6.1

... using external classes. Fixed Doctor's index rebuilding to use NULL values for missing values of new fields. ... a bug in retrieving primary key fields in queries (on index merging). Fixed a bug in using a collection field index in ...

 
forum_thread

Searching lists within objects

Hi everyone,  I've a problem with searching on lists. I'm uncertain as to what the best form is, so I've created a maven project with all the classes and a unit test showing my issue. Pretty much I want to search using cb.isMember passing an object. This however does NOT work. I'm uncertain how the database is doing its matching, but it looks to me like it matches using objectids, which means you can only match isMember if you have a database object. This does not help as I'm never going to have the real object at search time. ... type / value by defining a composite unique index on type and value (as shown above). Always look for existing ... use embedded objects: @ Entity @ Index ( members = { "attributeList.type" , ...

 
release

2.5.2

... using external classes. Fixed Doctor's index rebuilding to use NULL values for missing values of new fields. ... a bug in retrieving primary key fields in queries (on index merging). Fixed a bug in using a collection field index in ...

 
forum_thread

performance limit

Hi, can someone share expirience with performance limits of ObjectDB especialy when quering tables with large records sets. Our issue is with tables with 100.000+ records. Everything was OK when we had few thousand records. We have a simple SELECT statement which selects from a table with 100.000+ records by UserID atribute, tables have from 5 to 20 atributes. Usualy the results range from few hundred to few thousand records. This query takes up to 12 seconds. Is this normal, what when we will have few milion records, how to handle this. ... indexes that are not in use. Particularly, if a new index is defined for an existing entity that already has instances in the ... Runing the query in ObjectDB explorer clearly marks tha index on atribute createdBy is used. Can you please give some ... can process such queries very quickly. If a proper index is defined and in use the effect of the number of candidate objects is ...

 
release

2.6.3

... using external classes. Fixed Doctor's index rebuilding to use NULL values for missing values of new fields. ... a bug in retrieving primary key fields in queries (on index merging). Fixed a bug in using a collection field index in ...