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?