Auto Complete - Slow Load with Large Dataset

5 posts, 0 answers
  1. Linson
    Linson avatar
    1 posts
    Member since:
    Sep 2014

    Posted 08 Mar Link to this post

    I am using a AutoComplete control to which I am binding a large dataset (> 10,000) rows. These records are being read from sqllite local db. What I am experiencing right now is there is much delay in displaying the records in the suggestions list. Please let me know if there is a way to restrict the no of records being displayed and loaded into the control.

     

    Your quick response would be much appreciated.

     

     

  2. Jeena
    Jeena avatar
    3 posts
    Member since:
    Oct 2010

    Posted 09 Mar Link to this post

    I am also facing the same issue. Any help?
  3. Pavel R. Pavlov
    Admin
    Pavel R. Pavlov avatar
    1236 posts

    Posted 10 Mar Link to this post

    Hello,

    Could any of you please share more implementation details? I tested the control by loading into it 15000 business items and the performance of the RadAutoComplete is excellent. The results of the searching operation are displayed immediately. Please note that the list of the suggestions uses virtualization for better performance. This means that only the items that can fit into the viewport of the control are created and the same items are being reused over and over again. We do not create separate UI element for every single search result. 

    Could you please test if the items are loading fast enough from your database? This can be done by creating the items in code and repeating the same replication steps and observing the loading time. If the performance is slow again we would need to take a look at a concrete implementation in order to further investigate the case.

    Please let us know how it goes on your side.

    Regards,
    Pavel R. Pavlov
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  4. frank
    frank avatar
    5 posts
    Member since:
    Feb 2017

    Posted 19 Apr in reply to Pavel R. Pavlov Link to this post

    Hi Pavel, 

    I also have this issue. The itemsource is prepared in advance, and once the page is display, the automcomplete is really fast. The initial load of the page gets very slow the more items are in the source. On the android emulator it gets really slow with sources > 1000 items.

    Best regards, Frank

  5. Pavel R. Pavlov
    Admin
    Pavel R. Pavlov avatar
    1236 posts

    Posted 21 Apr Link to this post

    Hi Frank,

    Thank you for bringing this into our attention. However, as I already mentioned, we would need concrete implementation and/or repro project to test this setup on our side. It would be nice to share the exact emulator, as well. This will give us best chances to reproduce the same behavior on our side. We will be able to further investigate the reasons behind only after we reproduce this.

    Regards,
    Pavel R. Pavlov
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top