Temporary disabling of indexes?

#1

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, and can be rebuilt later?

#2

Disabling indexes requires removing the @Index annotations from the entity classes.

You should be able to load the data with no indexes and then add indexes (which will be built automatically starting version 2.6.6), but if the database is in use at that time before enabling the indexes they will not be available for all uses.

ObjectDB Support

Reply