Sizing Limits of Data Tables
Data table storage is limited only by the amount of available disk space that the database has access to. Despite this singular limitation, performance is based on the number of data rows in the data table.
• Data tables should not have more than 100,000 rows when queries are desired to take only a few seconds
• Anything greater than 100,000 rows (in PostgreSQL) will gradually begin to cause queries to perform slower
• For datasets with more than 100,000 rows of data, an external relational database should be used for optimal performance (and connected via a Database Thing)
Related Links