Search code examples
c#androidsqllarge-data

fetching data from too many record with some condition in SQL

I'm trying to fetch data from a table in sql with a condition using C#. I developed an android application using c# and it has a list and the main activity which fetches new rows from a table in sql, and whenever the user scrolls down, it takes a few seconds to load. Is there any possible way to improve the the fetching of these new rows so the user wont have to wait few seconds?

Solution

  • Use SELECT TOP 1 and whenever the user scrolls down more, it executes the query which selects top 1 row. Also use FULLTEXT INDEXES.