Creating secondary indices


#1

I haven’t found anything in the wiki or otherwise about creating secondary indices in 1.9.4 and the GUI doesn’t seem to have it when creating the schema. Is there a way to accomplish this with DF?


#2

Can you give an example of what you mean? You may find this page from the documentation helpful. It covers the DreamFactory simplified types and schema implementation. If you need to create DB structure that doesn’t fit what can be accomplished through the API, you could always just create it in the DB directly and then access it via the API.


#3

well if I want to search via a field not the primary key:

GET…?filter=uuid=E3242

from my understanding it would slow down at a high row count unless the DB was set to (secondarily) index the uuid field.