About index

51-60 of 200Refresh
Forum
23

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
Issue
23

"is not null" queries not working with index

"is not null"-queries are not working correctly for indexed fields. Following SSCCE creates 1000 entities. A null value is assigned to an indexed field for every second entity. When doing count ... .annotations.Index; import javax.persistence.Entity; import javax.persistence.EntityManager; import javax
Forum
23

"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
23

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
23

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
Forum
23

Indexes broken after schema update.

to pick up the new schema and now none of the indexes work, except the @Id. I can query by any field that is not indexed on the existing Object but as soon as I try and query against a field that was indexed I get no results. Tried 2.4.2 and 2.4.2_02 with same results. Adding new persistent fields
Issue
23

Internal Exception and Index Problems

with the index on that field. It is unclear how this happened, and unfortunately the Doctor doesn't include checks to identify this mismatch. However it is very easy to fix the index by running the Doctor in ... schema, it is possible that wrong data will be used by the server when an object is indexed
Forum
23

Partial Indexing

I have a question about partial indexing. For example, a field of String type ttt, will be distinguished by the first 5 characters, then I can make a index of substr(ttt,1,5) in MySQL. With ObjectDB, how can I write the annotation for this purpose? TIA Currently ObjectDB supports only indexing
Forum
23

Search through collection for value using index

by a paticular user, since I will do this query often I would like to index it.  How would I tell ObjectDB to make an index and then use it in a query? I have yet to deploy this entity so I could do something besides a java collection if there is a better approach. You can define an index
Forum
23

Check for index existence ?

Hello, Is there a simple way to check if indexes specified in entities are well taken into account by ObjectDb ? Regards, Xirt You can see query execution details, including usage of indexes ... well i got it after few minutes. Seems write in log is not immediate. Well, how can i check index