A simple query like
SELECT TOP 1 NodeID, ObjectSubType, IPAddress FROM Orion.Nodes
takes 1-2 seconds on the SWQL studio to get the data.
However when i try to fetch same data from the below query it says "Site cant be reached , then on multiple refreshes on the browser, it starts showing the result after approx 5 minutes.
https://<solarwindsserverIP>:17778/Solarwinds/InformationService/v3/Json/Query?query=SELECT%20TOP%201%20NodeID,%20ObjectSubType,%20IPAddress%20FROM%20Orion.Nodes%20
Troubleshooting this at https://thwack.solarwinds.com/t5/Discussions/slow-response-from-SWIS-API/m-p/590329.