Skip to main content
Inspiring
Jun 24, 2021 11:56 AM UTC
Question

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

  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
    Jun 24, 2021 1:38 PM UTC

    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.

    The Expression Guru
    csteward
    Brainy
    Jun 24, 2021 3:10 PM UTC

    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?

    gayathris111098
    Inspiring
    Jun 24, 2021 4:32 PM UTC