Skip to main content
June 24, 2021
Question

I have a view table which contains 100000 records. What measures are to be considered to obtain faster query results?

  • June 24, 2021
  • 3 replies
  • 0 views
  1. I have a view table which contains 100000 records. What measures are to be considered to obtain faster query results?

    3 replies

    mikes0011
    Brainy
    June 24, 2021

    This is very dependent on a few factors you didn't mention, such as 1) your use case overall, and 2) the particular implementation of the view including any inefficient/complicated logic or JOIN operations.

    csteward
    June 24, 2021

    Yes, definitely need some additional info on your use case here.  For example, I have a view with 5.9 million rows which is queried constantly with great performance.  I have another view over a table with 50k rows which performs much less efficient.

    How complex is your view?  How much data are you attempting to return at once / are you utilizing paging properly?  Is indexing applied in the DB?