performance of querry result

[shrisathe]

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

[ngervasi]

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)