JBoss AS pools Most services provided by the application server are granted by means of the pooling of resources. Keeping these resources in a pool avoids the burden of re-creating costly resources like database connections and can be used as well to limit the amount of requests to be processed by the application server. As […]
Using Prepared Statements efficiently When a database receives a statement, the database engine first parses the SQL string and looks for syntax errors. Once the statement is parsed, the database needs to figure out the most efficient plan to execute the statement. This can be computationally quite expensive. Once the query plan is created, the […]