3 ms·
If Teradata is faster for workload X or Y, it isn’t because of a shared nothing architecture. Databricks and Snowflake both cache the working set on local disks
by georgewfraser 6y ago
If Teradata is faster for workload X or Y, it isn’t because of a shared nothing architecture. Databricks and Snowflake both cache the working set on local disks of the worker nodes, so in practice they are shared nothing systems from a performance perspective.
- snidane 6y agoOnly after using the data beforehand it gets cached or by actively pushing it into cache. Otherwise everything sits in cold storage far away. And having control over the cache sucks as hell. You can't pin down a table to reside in compute node disk cache when you know it will be used often.