Hibernate Performance Tuning

Hibernate query performance tuning is a very big problem while coading.Tuning hibernate performance can be made easier by setting these simple properties in configuration file(default:hibernate.cfg.xml) or hibernate.properties

1)hibernate.show_sql ---- true/false ---- Writes all SQL statements to console. This is an alternative to setting the log category org.hibernate.SQL to debug.

2)hibernate.format_sql ----true/false---- Pretty print the SQL in the log and console.

3)hibernate.generate_statistics ----true/false---- If enabled, Hibernate will collect statistics useful for performance tuning.

4)hibernate.use_sql_comments ----true/false---- If turned on, Hibernate will generate comments inside the SQL, for easier debugging, defaults to false.

Hibernate Performance Tuning Document.
This document is very helpful for increasing hibernate performance.

Trick to get Windows XP’s Product key (CD Key, Serial Key) from CD itself

This trick which will be very much helpful in the case, if you don’t have the product key with your CD. It will take just few seconds; you just have to follow these 3 steps:

1. Explore the XP installation CD
2. Search for UNATTEND.txt , which will be inside i386 directory
3. Last line of the file will give you the Product Key of the CD

Installing MySql Query Browser in Ubuntu 9.10

Open your terminal and type.

$ sudo apt-get install mysql-admin mysql-query-browser

This command will download and install My-Sql Query Browser to /etc directory.

it will prompt for password.Enter it!

now every thing will be taken care automatically.

For running MySql-Query browser type the following in terminal

$cd /etc
$mysql-query-browser

now query browser will be launched.

----Enjoy

Installing My-Sql in Ubuntu 9.10

For Installation and use MySQL you have to give some instruction in terminal:

Step 1:

sudo apt-get install mysql-server

This will install the latest MySQL-server into your machine.

Step 2:

sudo /etc/init.d/mysql start

Which will start the MySQL server.

Step 3:

mysql -u root -p

This instruction will ask you the MySql server that you have entered during installation.

Step 4:

create database db_test

This instruction will create a new database “db_test”

Step 5:

use db_test

which will let you inside the database.