Rest API Speed

Support
#1

Hi
I am testing
http://localhost:8080/app/rest/v2/entities/myApp$Sales?limit=100&view=_local and I get the response in 4.2s

The app is running on Windows and is use Postgres. I use anonymous login.

Is this response time normal? how can I make it faster?

Thank you

#2

Hi,
usually it takes much less time to execute a simple query.
There may be many reasons that may increase the response time:

  • complex query in the database
  • the java application or database server are under the high load
  • not enough resources are allocated for java webapp or for the DB server

BTW, will you have such big time, if you execute this request for the second time? The first request always takes more time than all others. The problem may also be in fact that you made a request before the server is fully initialized.