Home » Search

About index

41-50 of 200Refresh
Forum
19

Slow searching with two indexes

a performance problem using two indexes.  An entity I'm querying has two indexed fields ... : select from Thing where reference == :objectReference order by id desc when an index is defined on the reference field should use that index and avoid a full scan. Does it run fast if the ORDER BY
Forum
19

Temporary disabling of indexes?

When populating a large database with objects that have indexed fields takes very much longer than populating the database with those objects if the index definitions are removed.  Is it possible to indicate in some way that for a particular use of the database indexes are to be ignored
Issue
19

Index Rebuilder

When a new index is added to an existing entity classes that already has instances in the database ... data. The Index Rebuilder tool will enable rebuilding indexes, synchronizing their data ... , in which such new indexes will be enabled. Version 2.6.6 introduces a built in automatic builder
Forum
19

Is there an administration tool with which I could create extra indexes?

Hello, I have composite index, and it was working fine, but now I need to add more features to the software and I need to throw more indexes in there. I wanted to know what's the best way to do this. 1. Have some admin tool CREATE INDEX..... ON a.b or 2. add more @Index to the object entities. in
Forum
19

Adding indexes on existing entities.

Is it safe to add indexes on an existing entity class? Thanks. Safe, but to enable the new index ... that the index is registered in the database by opening the database when it has access to the new index ... . Update: Starting ObjectDB 2.6.6 new indexes are automatically built and activated in the background
Forum
18

Create simple index for a Id field

Hello, I just wanted to write another anotation to my key field so I can have a really simple index ... just want my key to be indexed on my db, just like this: @Entity public class ObjectDbEntity implements DataItemProvider {        @Id     @Index     private Key key = null
Forum
18

JDO @Index in JPA?

Hi! I have a project which has all entities as JPA entities. I would like to make use of indexing ... : will adding JDO @Index in a JPA entity have any effect or I have to switch that entity to JDO? Question2 ... with JPA without any additional change. If you add an index to an existing entity class
Forum
18

"Rebuild Class Indexes" from the command line?

Hi, Is there a way to "Rebuild Class Indexes" from the command line? I have just added a new index ... . http://www.objectdb.com/database/jdo/manual/chapter9 Thanks   Rebuilding an index currently requires ... . Update: Starting ObjectDB 2.6.6 new indexes are automatically built and activated in the background. EKK
Forum
18

Are indexes implicitly created for relationships?

Do the following annotations @OneToMany @ManyToOne @ManyToMany @OneToOne imply @Index  ? Thanks ... on the @One side. But ObjectDB doesn't apply these indexes automatically, because of their overhead (which most users are not aware of). You should use the @Index or @Unique annotations explicitly to set indexes. FastModel
Forum
18

Index on values from a Map

Hi, is there a way to put an Index on the values from an Map? For example, if I have a Map like ... : Collection values = mmsContainer.values();   Thanks for you help   Indexes are used only in queries, and cannot accelerate other application code. You can define an index on a map