Expose APIs to manage indexes on collections

[giastfader]

No description provided.

[giastfader]

ATM indexes can be managed within plugins.
See giastfader@52e6fa3

[emresebat]

Hi @giastfader

I really need this, currently finding a record with string id on a 50000 collection takes around 1.5 - 2.0 secs. Is there an example for the plugin code?

[giastfader]

IDs are already indexed. Which query do you execute?

[emresebat]

Hi

ID's are indexed yes but my scenario is, I'm migrating data from parse.

So I have a plugin lib where I create an object with parseId, get the new baasbox Id and then match the related records from parse with the new ID. I have currently 3 collections, they're all related and while migrating I'm merging them in orientdb as a single document.

[giastfader]

Using the 0.9.4-nightly, try to create an index within a plugin:

Box.DB.exec("create property  <collection_name>.<field_to_index>  string");
Box.DB.exec("create index   <collection_name>.<field_to_index>  notunique"); //or unique depending on your use case

Refs:
http://orientdb.com/docs/1.7.8/orientdb.wiki/SQL-Create-Index.html
http://orientdb.com/docs/1.7.8/orientdb.wiki/Indexes.html