Just make sure you test for your scale and with representative data and queries. There will be various tipping points with any technology. But you can find them

Just make sure you test for your scale and with representative data and queries. There will be various tipping points with any technology. But you can find them with experimentation.