July, 2012
Cursor impact on Performance
Cursor usage should be avoided in procedures, functions and triggers. But if in some situations can’t be avoided then there is one important tip is for maximum performance. This is that cursor definition query should be kept simple as possible. The multiple tables joins and filters should not be used in cursor query. In below […]
Corrupt Connectsions
Is it possible that some of the connections (at EA Server) in the connection pool are corrupt for some reason, so when the application try to use these connections to execute SQL, the error of invalid handle will be thrown? This post was viewed (46) times.
Default number of connections in the connection pool?
Connection pool of EA Server , by default, is set to 30 and we at NetSol are using default properties in most of implementations. This post was viewed (28) times.