I know the Oracle-Java faster.
How so? Faster than what?
Any database with a JDBC driver is a good choice for work with Java.
Vasif Mustafayev wrote:Java-oracle the faster from all other.
As Paul said, without context this statement just does not make sense - so, stated like this, it is wrong. Oracle is definitely not faster than all other databases in all possible usage scenarios. It's likely that the design of the data access layer in your code will have much more impact on performance than the choice of DB.
I need know which I must use for my web Application which there are 10000 user in user_table
but this users not all active.
10000 is a very small number of records when it comes to relational DBs - all of them can handle that easily.
Java-oracle the faster from all other.
Am I right?
"Perhaps" is the only valid answer to this. Basically the question you are asking is too simplistic to answer any more extensively.
The size of data you are suggesting is really quite small, any database should handle this fairly easily.
[Ah Lester - you type too quick!]
Paul Sturrock wrote:I dislike MySQL for database purist reasons
MySQL has for ten years provided the InnoDB storage engine, which supports RI constraints and transactions. In MySQL 5.5, InnoDB is the default storage engine (finally), and over the last few years InnoDB has been improved so it's faster than MyISAM in most cases.
I agree MySQL still has a few WTF moments (whither check constraints? raise error in triggers? recursive CTEs?), but all RDBMS implementations have their own idiosyncrasies.
But like I say, this is more of a personal prejudice. Choosing to use it with the knowledge of its failings is fine.
On the other hand, Oracle supports foreign key constraints -- except not cascading updates. Also, an empty string in VARCHAR2 is the same as a null, which makes them incompatible with ANSI/ISO SQL and every other vendor's implementation of SQL. This, they cannot fix? They've been the 2nd largest software company in the world for decades!
That's what I mean when I say every database has its idiosyncrasies.