performance of querry result

Classic Servoy
1

I would like someone to compare performance of select / insert statement in servoy with native select / insert querry in sql serve 2008 database

2

What do you mean exactly with “native”? Servoy connects to the DB via JDBC, the workflow is this:

  • client asks servoy server for data (client-server connection latency matters here)
  • server picks up a connection from the connection pool
  • server sends the query to the db via the connection (server-db connection latency matters here)
  • server waits for the db to execute the query
  • server gets the result back (server-db connection latency matters here)
  • server sends the data back to the client (client-server connection latency matters here)

The keys for performance are:

  • keep the servoy server as “close” as possible to the db server so that latency is minimal
  • if you use smart client watch out for client-server latency
  • try to reduce the number of queries sent to the db (one big query is faster than multiple small queries, due to latency)