get_schedule_details peformance question.

[Denis Kostromitskiy]

Hi, guys.
I have windows agent and there are 31 OS updates available for it.
I've created Schedule to install all those updates.
The issue is when I trying to get info for that Schedule, it takes about ~38sec to fetch the data. I think when there will be more data, it'll take forever for request to finish.

GET
https://localhost/api/v1/schedule/New

Call chain:
GET
ScheduleAppDetailHandler
get_schedule_details
get_agent_apps_details
...

What could be the issue there? Is it because I'm not using SSD for rethinkdb?

[Denis Kostromitskiy]

I guess it also could be because of small amount of memory on the server (2Gb). When I increased it to 3Gb, reading speed increased up to 10k.. 

[Allen Sanabria]

Definitely the lack of ram and ssd is an issue, but it's not the underlying issue. The original get schedule methods were making to many round trips to the database, which is the real reason as to why it is slow. I rewrote the scheduler for the next release which addresses these performance issues.