Question about server setup

Unknown

Question about server setup

Unknown

Hello,

Would you recommend running the database and application on the same server ?
We are seeing a lot of network latency when we run our flows and we are wondering if putting them on the same server would help with this.
However, if there are things we are not thinking about that would cause them to be negative we want to consider this.
Also, we have a workflow now that is writing to the database and then fetching it and the performance is not great and we are wondering if this was running with a local database,would it help.

Thanks.

Unknown

Hello,

We typically do not recommend putting the database on the same server as production for one reason. Both Decisions and SQL tend to want to hog RAM and system resources and so with heavy processing. Putting them on the same server could cause them to try to fight for the same resources. By putting them on separate servers, this helps to share the load. If you are experiencing network issues, putting the database on the same server as the Decisions application would help to resolve this as we would not have to go over the network. So, some of the above concerns could be addressed with a very powerful server. It might be better if we help determine the slowness between database and Decisions and instead help to optimize. I would be happy to setup a meeting with a developer so we can start to determine the best steps moving forward to increase performance. Let me know how you would like to proceed.

Thanks.