Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Thursday, 30 January 2014

HikariCP connection pool

"HikariCP - here is nothing faster. There is nothing more correct. HikariCP is a “zero-overhead” production-quality connection pool. " - sounds great) Need to check it

 http://brettwooldridge.github.io/HikariCP/

Tuesday, 26 June 2012

Java: MongoDB simple example


MongoDB - is an open source document-oriented NoSQL database system. Next I will create simple servlet example that's uses MongoDB. 

Tuesday, 21 February 2012

C3P0 ConnectionPool: How To configure

C3P0 - is a connection pool,  connection pool is a cache of database connections maintained, so that the connections can be reused when future requests to the database are required. 


The main question is how to cofigure it, because default values are not perfect. First of all I found oficial doc with description of the values. Next I found this one C3P0 ConnectionPool Configuration Rules of Thumb. After some performance testing of my application, I can confirm that configuring like in this article, can greatly increase your performance, in my case it was about twice. So bellow text of this article -  "

Tuesday, 3 May 2011

Wednesday, 27 April 2011

Java: Loading data from file into a Oracle database


It's possible to do using Sql Loader.SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.

Friday, 28 January 2011

Java: Using SQLite

SQLite - is embedded relational database management system.In other words you can use sql database without server.

Saturday, 25 December 2010

Java: JDBC basics

JDBC is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database.