what is good, mysql or oracle??
 

i want to use a db that is easily integrable with java, can support more number of load and which searches the db really fast and the sorting is also fast...
which one should i use...

The major advantage of Oracle is that it has a nice graphical front-end, as well as being a very poewrful database system. MySQL, on the other hand, is free software and therefore tends to be cheaper.

[[EDIT: By “major advantage” I mean “major advantage as compared to MySQL or PostGreSQL”]]

You might also look at PostGreSQL, which is like mysql but tends to be more fully featured (implements more of the optional parts of SQL like hierarchies, multiple databases etc.), and I know it has good query/searching optimisation. It's also free to use even for commercial applications.

All three of these will integrate well with Java via JDBC drivers, and have been used in situations where a very high load is required.

Personally, I tend to use PostGreSQL.

Umm.. yes... I would say either MySQL or PostgreSQL.... I guess you just have to weigh your options... Oracle and IBM DB2 both have graphical front-ends... (I've only used DB2 and I personally thought the GUI SUCKED SHIT!) But aside from that... DB2 is like $8,000 per processor to run it on... and Oracle is lik $11,000... so umm... Your choices are:

FREE (with option to pay for top-notch support)

or

$$(The cost of an amazing new database server for yourself while using MySQL or Postgre)$$

The choice is yours... I know mine...

depends on what you want to do with it I guess. oracle and mysql (or postgresql) both have their advantages. a note about speed: i've never heard anyone complain about any of these!

i personally stick with mysql, but then again i might go for postgresql if i was using it for commercial purposes.

Dude, you got that totally the wrong way around. The major advantage of Oracle is that it is a very powerful database system.

It might have a nice graphical front-end, but that's not actually Oracle. It's a separate application.

Unless you're building a corporate system I'd forget about Oracle. You'll never afford the licences.