3 ms·
At what performance threshold should one migrate from a relational database to a graph database? In other words, is there something like OtterTune that can help
by mihirmp 3y ago
At what performance threshold should one migrate from a relational database to a graph database? In other words, is there something like OtterTune that can help me figure out the best storage engine (SQL vs NoSQL vs Graph vs Timeseries) for my service based on traffic patterns?
- apavlo 3y agoAndy from OtterTune here. I suppose that it is possible to do something like this. We've explored the idea of synthesizing a workload that behaves like an application's real workload. The idea was to do offline testing with the synthesized workload to find optimal configurations that can then be applied to the production database. Our results were inconclusive (not enough real workloads to verify). But the idea could be extended for what you are proposing. But in terms of relational vs graph, my opinions about the matter are public: https://www.theregister.com/Debates/2023/03/06/great_graph_debate/ https://www.theregister.com/Debates/2023/03/06/great_graph_d...