While we try and run the queries as simple as
"SELECT TOP 1 NodeID,ObjectSubType,IPAddress FROM Orion.Nodes" i get the response immediately on the SWQL studio. However when i try and fetch the same data from the query like below:
https://<SolarwindsIP>:17778/Solarwinds/InformationService/v3/Json/Query?query=SELECT%20TOP%201%20NodeID,%20ObjectSubType,%20IPAddress%20FROM%20Orion.Nodes%20
It takes a lot of time. It instantaneously says "Site cant be reached" . On pressing refresh for 4-5 times , it starts showing the data after 5 mins.
What am i missing ? Is that something that needs to be checked on the server ?