Regarding too much time in api calls
1GB is very low for that number of devices. Also everything depends on how much data you get in that report. How many items?
Actually we are using 2 gb ram and around 1 gb is available free. And we also created one more server which has only one device in that we are getting responses time around 10 sec.
what can be a issue?
Check the database query. I suspect it's just slow.
Are you using SSD drives?
yes we are using ssd
can you help me out to find the solution because I am still struggling to find the solution
Have you checked the SQL request?
when I am hitting this api I am getting response time 20 sec which is making our user experinece bad
resources we have provided 1gb ram database size is 25 gb and devices we have in our server is 80.