Growing tables and query delays

2 posts, 0 answers
  1. İlkay
    İlkay avatar
    6 posts
    Member since:
    Jul 2015

    Posted 28 Jun 2016 Link to this post

    I have a backend table for my native application. The number of record is growing fast. What is the constraints for data query of high loaded tables?

    For example, if a table has 500.000 data, will it be any delay during data query/insert/delete/update on this table?

    Thanks much.

  2. Dimitar Dimitrov
    Dimitar Dimitrov avatar
    26 posts

    Posted 30 Jun 2016 Link to this post

    Hi İlkay,

    Currently we do not have any clear constraints set for the query performance over large database. It is expected to have a small delay of the crud operation along with the increasing number of items in your tables.

    Basically the structure of your tables and the type of queries are the main thing to consider.

    To be more specific the create operations might not be affected as much as the other operations - read and update queries, which depend on the number of items in the table. By default there are no indexes created on any field. This means that if you have a set of such operations, they can be additionally optimized by creating an index depending on the type of query. We can assist with this as soon as you experience any slowness of your queries. The delete operations also depend on the type of filter that you provide.

    Hope this information will help you.

    Dimitar Dimitrov
    Everlive is now Telerik Backend Services, and is part of the Telerik Platform.
Back to Top