0

Spinning wheels

When I move from table to table, I sometimes get spinning wheels I can go on for 20 for 30 seconds.

 

When I move from table to table, I sometimes get spinning wheels I can go on for 20 or 30 seconds.

 

This can occur when in fact, there is no select statement being processed, for example 

4 replies

null
    • Elena_Rodriguez
    • 1 yr ago
    • Reported - view

    The same happens to us with Tables that contain many rows...
    Is this also the case for you?

      • NYNNA
      • Louis_Cornacchia
      • 1 yr ago
      • Reported - view

        No. I have tables with hundreds of thousands of rows, and its almost imperceptibly slow. The problem was traced to multiple VIEW fields each with there own select statements. I thought that View fields resolve only if displayed. Not true. all view fields are resolved on opening the table. Fixed this by adding a conditional to each view field calculation so it triggers only when needed. 

      • Elena_Rodriguez
      • 1 yr ago
      • Reported - view

      Thank you! I will check our tables for this.

    • Fred
    • 1 yr ago
    • Reported - view

    I just encountered something similar, but slightly different. A table that use to load fine, but has suddenly slowed down. This time there were no major changes to the table structure.

    I have two table views in the table and one would take 30 seconds to load but the other would load fine. The views have the exact same columns just show two different filters. So I made a new table view based on the quick loading view. Then deleted the bad view and now all works fine.

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 4Replies
  • 121Views
  • 3 Following