Re: Best database for web backend on Linux?
This is a multi-part message in MIME format. ------=_NextPart_000_0322_01BDFD02.DEA10B60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Evan, As they say YMMV. In my case switching from page level locking to = row level locking on a client/server application using Informix resulted = in substantial performance improvements. The application has several = users going after the next available record to verify and correct it. regards Jerry Evan Carew wrote in message <362DE1DF.CEFF3539@yahoo.com>... Chris,=20 Read my earlier posting on this topic for an example of how to get = arround this problem=20 ans save your self a boatload of performance.=20 I've noticed there seems to be resistence to the notion that row = level locking is not as usefull=20 the marketing people would have us think. To put it in perspective, = The last three organizations=20 I have been contracted to where I was called in to fix performance = problems associated with=20 row level locking issues, at least the manager and usually one or = two of the top developers were=20 "transferred" off the project when it was shown how much faster = their product could have been=20 running had they never pushed for row level locking.=20 I'm not saying that row level locking is a bad idea for all = projects, especially if you want to=20 put together some kind of brain dead demo, or need to get something = to work TODAY and=20 have every intention of cleaning it up later. Just remember that if = one of these projects ends=20 up mission critical you better sell it as an interum product to CYA. = All it takes is one well=20 trained DBA/App Developer to come by and make it go 20x faster to = really embaras someone.=20 (snip) ------=_NextPart_000_0322_01BDFD02.DEA10B60 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.72.2106.6"' name=3DGENERATOR> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2>Hi Evan,</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT color=3D#000000 size=3D2> As they say = YMMV. In my=20 case switching from page level locking to row level locking on a = client/server=20 application using Informix resulted in substantial performance=20 improvements. The application has several users going after the = next=20 available record to verify and correct it.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT size=3D2>regards</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Jerry</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV> </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:362DE1DF.CEFF3539@yahoo.com">362DE1DF.CEFF3539@yahoo.com</= A>>...</DIV>Chris,=20 =20 <P>Read my earlier posting on this topic for an example of how to = get=20 arround this problem <BR>ans save your self a boatload of = performance.=20 <P>I've noticed there seems to be resistence to the notion that row = level=20 locking is not as usefull <BR>the marketing people would have us = think. To=20 put it in perspective, The last three organizations <BR>I have been=20 contracted to where I was called in to fix performance problems = associated=20 with <BR>row level locking issues, at least the manager and usually = one or=20 two of the top developers were <BR>"transferred" off the = project=20 when it was shown how much faster their product could have been = <BR>running=20 had they never pushed for row level locking.=20 <P>I'm not saying that row level locking is a bad idea for all = projects,=20 especially if you want to <BR>put together some kind of brain dead = demo, or=20 need to get something to work TODAY and <BR>have every intention of = cleaning=20 it up later. Just remember that if one of these projects ends <BR>up = mission=20 critical you better sell it as an interum product to CYA. All it = takes is=20 one well <BR>trained DBA/App Developer to come by and make it go 20x = faster=20 to really embaras someone.=20 <P><FONT color=3D#000000 size=3D2>(snip)</FONT> <P><FONT color=3D#000000 = size=3D2></FONT> </P></BLOCKQUOTE></BODY></HTML> ------=_NextPart_000_0322_01BDFD02.DEA10B60--