Re: Oracle alternatives

My experience is that I am not going to say anything anymore against any database until I know the application and business requirements together with proper knowledge of these databases I am talking about.

Every database can have very good usage for what is the best for.
My experience was that Oracle did not cover many simple things these smaller databases are providing to you.

My main concern in the last 2 years was the speed of reference lookups for the biggest telecom companies.

I could not believe that Oracle is failing on this simple thing for unknown reason.

As Nuno Souto said Oracle did not pay any attention to have slim version of Oracle probably because it is so hard to do anything now when the code, features and everything is intermingled together.

We needed to test Berkley DB, MySQL, TimesTen and many others to evaluate which database to use for fast reference lookups.
We picked TimesTen because it was 6 times faster in lookups and used SQL. We needed the only one strong reason to pick TimesTen. Other companies are using MySQL, SleepyCat and others to do their jobs perfectly.

Oracle of course has crazy algorithm inside the database engine and inside the PL/SQL (associative arrays) written in C but never exposed to the client side, so making these small database engines living nicely (not just for that reason, but it is very big reason if you can save on the number of CPU's 6 times on some particular business action).

At the end, every database is useful and good when applied to the specific business requirements.

Regards,
Zoran Martic                 

Yahoo! Mail
Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html

--
http://www.freelists.org/webpage/oracle-l