Most applications start fast because the dataset is small. As the system grows and millions of rows accumulate, queries that once executed instantly begin to slow down, and over the period user starts noticing:
· Slower GUI
· Reports that ran instantly now take minutes
· Time Out Errors from APIs
· Latency in