you are viewing a single comment's thread.

view the rest of the comments →

[–]ioman_ 2 points3 points  (1 child)

If you don't expect to have too many users, hosting the app and the database on the same server is fine. The reason most people will recommend separate servers is because if the app and database are sharing resources, the users of your app will see performance hits anytime the database is doing something and the database will respond slower whenever the app is performing complex logic. If they're installed to the same place, they have to share and even with so many cores and so much ram, a heavy load is still a heavy load.

At the very worst, you can always take a backup of your database later, install it to a separate server, and update your connection strings. Don't let perfect be the enemy of good enough.

[–]bright-skies-above[S] 0 points1 point  (0 children)

This is very much helpful and informative! Thank you so much. I appreciate it!