Does anyone have any sort of experience with cloud (i know) MS SQL server hosting?
I have looked at Azure but afaik it's unusable with any tier that's less than $30/month. I wonder if there are more affordable hosts elsewhere
My database wouldn't be too big, basically one table with 4-5 columns, but i expect 100+ clients accessing it every day, ~once per minute
Anyone went this shitty road to give some advices?
cmon, no one?
>>58107002
>My database wouldn't be too big, basically one table with 4-5 columns, but i expect 100+ clients accessing it every day, ~once per minute
You do realize that this is completely useless as it gives no details of the query. Anyways any cloud hosting is going to suck shit unless you pay actual money like you said, because the host will be horribly overprovisioned.
Check out Scaleway
Cloud is useless for you, and too expensive no matter which host you choose
100 or even 1000 requests to a database every minute is nothing, especially if it's a simple query and it probably is given the small size of your one table.
If you have data that is getting accessed frequently, I would look into caching the database results into memory instead of buying expensive hardware that you don't need. Most importantly, first deploy, then profile. If you don't have actual performance data, then it's going to be hard to optimize your server/db.
>>58109155
>I would look into caching the database results into memory
How does this help if new data are being entered every minute and clients search for new data in the same interval?
>>58109352
Why dont you just run your own SQL server at home if you cant afford $30 a month? If it is for a business venture and you need 5 9s uptime than $30 a month is pocket change.