Re: Best database for web backend on Linux?

I pin my common procedures, so they don't get blown out of the cache. In Oracle I have fairly good control of what tables and procedures I want maintained in the cache.

Thor HW
Evan Carew wrote in message <362DDBB5.8E58F13A_at_yahoo.com>...

    Thor,
    Simply put, The main reason I have selected Sybase over Oracle in the recent past has to do with cache management. In every case, if

    you try to use Oracle stored procedures in the same environment with large queries, you will end up blowing the oracle stored procedures

    out of cache, thus forcing them to be reloaded from memory. This one requirement is frequently enough to take Oracle out of the running.     

    BTW, those math problems you had, were those on a 10.X or early 11.x version?     

    Thor wrote:     

     Interesting. I've done lots of Sybase work, and found I could tune Oracle to be faster than Sybase in everything except for loading a clustered index in reverse order where the data was already pre-sorted. If left to a random distribution it was faster than Sybase. Also if you push sybase for extended periods of time, their delayed mechanism really starts to hurt you. For accounting applications I found the dirty read to be a great problem when doing trial balances. I also found the math module in Sybase to SUCK! I mean we got different answers when running the exact same stored procedure on DEC VMS, UNIX, etc. It uses the host mathlibs, which on VMS aren't all that hot. Now if you take the benchmark that "Corporate Computing" does, you'll see that Oracle still kicks ass. But you can always slow down anything, if you try hard enough. Corporate computing takes an application from a real business, loads it onto any rdbms with guts to enter the contest, and then runs typical queries, indexing, loading, inserts, etc, that the business does in a regular work year.Now that's a real bench mark. Sun has a cool benchmark, as does Qualcomm, and Oracle always does well in those environments. REGARDLESS, having to write 40% less code, because the rdbms does row-level locking for you is worth it to me. Thor HW

        
            
            -- 


----==--                       / /  \

---==---( )                   / / /\ \

--==---/ /   \/ // /\ \/ /   / / /\ \ \

-=====/ / // /\ , / / /\ \  /      \ \ \
A proud member of TeamLinux \         \/
email: carew@home.msen.com web: http://home.msen.com/~carew
      

--
Received on Thu Oct 22 1998 - 00:00:00 CDT