Sage 300 installed on Ec2 using RDS for SQL Database

I am currently experiencing an issue where i installed and set up sage 300 application on AWS EC2 instance and connected to RDS SQL for the database

Everything works fine besides when i run queries it is really slow and takes 5 mins when it should take less than 30 seconds to run

There no issues on the infrastructure wise as i've checked with AWS support, EC2 and RDS is in the same zone and there's no latency or delay so the network isn't the issues, 

resources isn't an issue either as CPU and ram aren't even using 2& while running queries. 

Is anyone familiar with this cloud setup or can explain why ia m experiencing issue? 

Parents Reply Children
No Data