Re: Best database for web backend on Linux?

Posted in 1998

Evan Carew — Wed, 21 Oct 1998 13:03:49 +0000 — source: Informix-list mailing list archive (1991-1998)

--------------86E599831073FEE03ABF93FF Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 --------------86E599831073FEE03ABF93FF Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> <BODY BGCOLOR="#FFFFFF"> 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: <BLOCKQUOTE TYPE=CITE> 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 <BLOCKQUOTE style="BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">  </BLOCKQUOTE> </BLOCKQUOTE> <PRE>--  ----==-- _                     / /  \\ ---==---(_)__  __ ____  __    / / /\\ \\ --==---/ / _ \\/ // /\\ \\/ /   / /_/\\ \\ \\ -=====/_/_//_/\\_,_/ /_/\\_\\  /______\\ \\ \\ A proud member of TeamLinux \\_________\\/ email: carew@home.msen.com web: <A HREF="http://home.msen.com/~carew">http://home.msen.com/~carew</A></PRE>;   </BODY> </HTML> --------------86E599831073FEE03ABF93FF--