This is a migrated thread and some comments may be shown as answers.

Design consideration for indexes / Querying

3 Answers 38 Views
General Discussion
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Craig
Top achievements
Rank 1
Craig asked on 31 Mar 2014, 02:06 AM
I'm aware that Backend Services is built on top of MongoDB, so the whole concept of database relations and indexing is not the same. However, since the portal allows you to define "relations" to other types, and the volume of data will grow... what options are there for making sure your backend data service continues to be responsive as data volumes grow? Specifically, how to access data for a specific userId where new userId's will continually be added?

I've been unable to find any documentation on this subject. One of the SDK's (.Net) vaguely referenced this subject in the Querying / Filtering section, but nothing specific...

I find it hard to believe that "indexing" does NOT need to be considered in the design of a new backend service? But I don't see where we as the developer have any control over this in the current version of the portal?

Please advise - thanks

3 Answers, 1 is accepted

Sort by
0
Anton Dobrev
Telerik team
answered on 31 Mar 2014, 04:27 PM
Hello Craig,

Thank you for your question! You are right, that indexing is a central part of a backend design. In addition, all the specifics of the NoSQL data stores demand to be handled design-time in order to ensure the best performance of the data store and the apps that are using it. Unfortunately, our documentation is somewhat scarce on this topic and it is in our plans to enhance it.

Telerik Backend Services ensures automatically the index on the Id of an item. So, in terms of querying, a search on an Id would work as it is expected to work on indexed fields. Though we are aware that our customers would like to implement a diverse searching functionality in their apps, we are still evaluating the option to allow developers to create indexes on additional fields.

In general, queries using '$where', '$nin' and '$neq' operators are slow and should be avoided (even in the presence of an index on this field).

Please, let us know if further questions occur.

Regards,
Anton Dobrev
Telerik
 

Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

 
0
Greg Galipeau
Top achievements
Rank 1
answered on 02 May 2015, 01:56 PM

Seeing as how this is over a year old and I am still having issues finding documentation on this subject - did Telerik ever implement the ability to index fields? I am about to build a fairly large implementation kn this platform and would like to index a column I know we will be querying off of quite regularly.

 

 

0
Anton Dobrev
Telerik team
answered on 05 May 2015, 03:31 PM
@Greg

Thanks for your input. We do understand the need for creating custom indexes, but however, this is still not exposed as a functionality to the developers that use Telerik Backend Services. The information above is still relevant and the only indexed field remains the Id.

Please, let me know if you have further questions or suggestions.

Regards,
Anton Dobrev
Telerik
 
Everlive is now Telerik Backend Services, and is part of the Telerik Platform.
 
Tags
General Discussion
Asked by
Craig
Top achievements
Rank 1
Answers by
Anton Dobrev
Telerik team
Greg Galipeau
Top achievements
Rank 1
Share this question
or