CHROMIUM

Welcome to CHROMIUM's very own blog!

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 (48) 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 (29) times.

Next posts