Yes - often what once worked when the application only had a few hundred or thousand records doesn't work anymore, now that it has millions of records. Those m

Yes - often what once worked when the application only had a few hundred or thousand records doesn't work anymore, now that it has millions of records. Those milliseconds, N+1 queries, nested queries, large joins (owing to incongruence between logical data structure and how that data is stored on disk) and poorly-indexed tables combine into lots of sad times.