From oracle-l-bounce@freelists.org Mon May 9 03:48:35 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j498mZXU010151 for ; Mon, 9 May 2005 03:48:35 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j498mY4Z010147 for ; Mon, 9 May 2005 03:48:34 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 169BB191737; Mon, 9 May 2005 02:45:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01087-09; Mon, 9 May 2005 02:45:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9493619153C; Mon, 9 May 2005 02:45:53 -0500 (EST) Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=SGmiyZfv2lPInEI1GksP51qUDhTr7Y15sr5ynpgcjNz9X8BeOZb7XbRpzllhXHQfVct9ksDaM2ZpFX4lygLQ2k6hRxvlrtVWNrRym2ih+vzvxp5uH50y0Z6ISPzP3IpWS+oEQ40TkS9K64TGaqEFZEaz9R+nD5LyTJRGrYkGLtw= ; Message-ID: <20050509074405.64117.qmail@web52608.mail.yahoo.com> Date: Mon, 9 May 2005 00:44:05 -0700 (PDT) From: Martic Zoran Subject: Re: Oracle alternatives To: Oracle-L Freelists In-Reply-To: 6667 MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 19438 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: zoran_martic@yahoo.com Precedence: normal Reply-To: zoran_martic@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.5 required=5.0 tests=AWL,FORGED_YAHOO_RCVD autolearn=no version=2.63 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