We're in the process of publishing our mobile app to the Apple and Google stores, but I'm somewhat concerned about latency and speed issues.
I've always paid for the same shared host (which I never actually use), but I recently purchased three other shared SQL Server hosts.
All three have the same DB objects, and I want execute a stored procedure that returns all 90 rows from a table.
Locally, I'll connect to the hosts via SSMS, run the SP and compare the latency results. The one with the lowest latency will host our app database.
Is there something that straightforward? It doesn't have to be an exact science; it's just something to easily measure speeds.
My goal is that, whatever issues may arise from the app, I can be certain that the database backend is not one of them.