What Is a “No Data” Application

There are a lot of data-driven lines of business applications that will never have a million rows before they get replaced by something else. I call these « no data » applications because they have so little data the database server will never require many optimizations if any. The default settings are good enough.

Postgres can find any row out of a million on your corporate craptop in a relatively slow docker for windows container in 2 ms with any reasonable index. Oddly enough, it will get much faster performance in the cloud, where the vendor has undoubtedly optimized the database code for their particular infrastructure.

Source de l’article sur DZONE