This is difficult to tell because many factors a role. It's best to try it on your machine. Generate data and query them.
Don't forget to optimize your settings. They are far from optimal after installation.
Am 5. November 2020 14:33:54 MEZ schrieb Yambu <hyambu@gmail.com>:
Hi
What cost is involved in querying a table that has 100k rows versus one that has 20mil rows, and what are the specific advantages in terms of memory,speed etc when a table is smaller?
regards
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -