Re: Best database for web backend on Linux?
This is a multi-part message in MIME format. ------=_NextPart_000_1916_01BDFD9B.6C0CD360 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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@yahoo.com>... Thor,=20 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=20 you try to use Oracle stored procedures in the same environment with = large queries, you will end up blowing the oracle stored procedures=20 out of cache, thus forcing them to be reloaded from memory. This one = requirement is frequently enough to take Oracle out of the running.=20 =20 BTW, those math problems you had, were those on a 10.X or early 11.x = version?=20 =20 Thor wrote:=20 =20 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=20 =20 =20 --=20 ----=3D=3D-- _ / / \\ ---=3D=3D---(_)__ __ ____ __ / / /\\ \\ --=3D=3D---/ / _ \\/ // /\\ \\/ / / /_/\\ \\ \\ -=3D=3D=3D=3D=3D/_/_//_/\\_,_/ /_/\\_\\ /______\\ \\ \\ A proud member of TeamLinux \\_________\\/ email: carew@home.msen.com web: http://home.msen.com/~carew =20 ------=_NextPart_000_1916_01BDFD9B.6C0CD360 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2>I pin my common procedures, so they = don't get=20 blown out of the cache. In Oracle I have fairly good control of = what=20 tables and procedures I want maintained in the cache.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Thor HW</FONT></DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px"> <DIV>Evan Carew<ECAREW@YAHOO.COM> wrote in message <<A=20 = href=3D"mailto:362DDBB5.8E58F13A@yahoo.com">362DDBB5.8E58F13A@yahoo.com</= A>>...</DIV>Thor,=20 =20 <P>Simply put, The main reason I have selected Sybase over Oracle in = the=20 recent past has to do with cache management. In every case, if = <BR>you try=20 to use Oracle stored procedures in the same environment with large = queries,=20 you will end up blowing the oracle stored procedures <BR>out of = cache, thus=20 forcing them to be reloaded from memory. This one requirement is = frequently=20 enough to take Oracle out of the running.=20 <P>BTW, those math problems you had, were those on a 10.X or early = 11.x=20 version?=20 <P>Thor wrote:=20 <BLOCKQUOTE TYPE =3D CITE> <FONT color=3D#000000><FONT=20 size=3D-1>Interesting. I've done lots of Sybase work, and = found I=20 could tune Oracle to be faster than Sybase in everything except = for=20 loading a clustered index in reverse order where the data was = already=20 pre-sorted. If left to a random distribution it was faster = than=20 Sybase. Also if you push sybase for extended periods of = time,=20 their delayed mechanism really starts to hurt you.</FONT></FONT> = <FONT=20 size=3D-1>For accounting applications I found the dirty read to = be a great=20 problem when doing trial balances.</FONT> <FONT size=3D-1>I also = found the=20 math module in Sybase to SUCK! I mean we got different = answers=20 when running the exact same stored procedure on DEC VMS, UNIX,=20 etc. It uses the host mathlibs, which on VMS aren't all = that=20 hot.</FONT> <FONT color=3D#000000><FONT size=3D-1>Now if you = take the=20 benchmark that "Corporate Computing" does, you'll see = that=20 Oracle still kicks ass. But you can always slow down = anything, if=20 you try hard enough. Corporate computing takes = an=20 application from a real business, loads it onto any rdbms with = guts to=20 enter the contest, and then runs typical queries, indexing, = loading,=20 inserts, etc, that the business does in a regular work year.Now = that's a=20 real bench mark. Sun has a cool benchmark, as does = Qualcomm, and=20 Oracle always does well in those environments.</FONT></FONT> = <FONT=20 size=3D-1>REGARDLESS, having to write 40% less code, because the = rdbms=20 does row-level locking for you is worth it to me.</FONT> <FONT=20 color=3D#000000><FONT size=3D-1>Thor HW</FONT></FONT>=20 <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; = PADDING-LEFT: 5px"> <P> </P></BLOCKQUOTE></BLOCKQUOTE><PRE>-- ----=3D=3D-- = _ = / / \\ ---=3D=3D---(_)__ __ ____ __ / / /\\ \\ --=3D=3D---/ / _ \\/ // /\\ \\/ / / /_/\\ \\ \\ -=3D=3D=3D=3D=3D/_/_//_/\\_,_/ /_/\\_\\ /______\\ \\ \\ A proud member of TeamLinux \\_________\\/ email: carew@home.msen.com web: <A = href=3D"http://home.msen.com/~carew">http://home.msen.com/~carew</A></PRE= > =20 </BLOCKQUOTE></BODY></HTML> ------=_NextPart_000_1916_01BDFD9B.6C0CD360--