Re: Best database for web backend on Linux?
--------------BA9AF6686A493C3698498840 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jed, Jed S. Baer wrote: > In article <362DE1DF.CEFF3539@yahoo.com>, ecarew@yahoo.com says... > > I'm not saying that row level locking is a bad idea for all projects, > > especially if you want to > > put together some kind of brain dead demo, > > Indeed! As an Oracle DBA/Developer, I can tell you that none of my > projects fit this category, neither did they suffer from performance > problems. Glad to hear it! I'll bet you tho if it were not dependant on RLL (sorry but I'm getting tired of typing row level locking all the time) one if not both of the following would happen: 1. The cost of hardware for supporting the application would go down due to lower resource usage 2. The capacity and performance of your already zipy application would increace noticably. > > > > All it > > takes is one well > > trained DBA/App Developer to come by and make it go 20x faster to really > > embaras someone. > > Now, you've got it. The question of database design and development can't > be answered by focusing on only lock strategies. Yes, they're important, > but only part of the picture. And database tuning is a multi-faceted > discipline. Good point. If I could add to that with some of my own anecdotal experiance, The presence of RLL often suggests to me that the project is being managed by VB programmers. Not that I have anything against VB, but it is all too often used as a development tool by the inexperienced programmer. While cleaning up the RLL in this case might cure some of the performance bottleknecks, there are bound to be scads of other problems in the design that weigh it down. > > > > > > Christopher Browne wrote: > > > > > >Generaly speaking, row-level-locking is regarded to be a design flaw > > > >anyway, so you probably don't want to rate that feature too highly. > > I'm curious, by whom? Certainly not Oracle corp. > Duh! [sais the Oracle marketing department] -- ----==-- _ / / \\ ---==---(_)__ __ ____ __ / / /\\ \\ --==---/ / _ \\/ // /\\ \\/ / / /_/\\ \\ \\ -=====/_/_//_/\\_,_/ /_/\\_\\ /______\\ \\ \\ A proud member of TeamLinux \\_________\\/ email: carew@home.msen.com web: http://home.msen.com/~carew --------------BA9AF6686A493C3698498840 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> Jed, <P>Jed S. Baer wrote: <BLOCKQUOTE TYPE=CITE>In article <362DE1DF.CEFF3539@yahoo.com>, ecarew@yahoo.com says... <BR>> I'm not saying that row level locking is a bad idea for all projects, <BR>> especially if you want to <BR>> put together some kind of brain dead demo, <P>Indeed! As an Oracle DBA/Developer, I can tell you that none of my <BR>projects fit this category, neither did they suffer from performance <BR>problems.</BLOCKQUOTE> Glad to hear it! I'll bet you tho if it were not dependant on RLL (sorry but I'm getting tired of typing row level locking all the time) one if not both of the following would happen: <BR>1. The cost of hardware for supporting the application would go down due to lower resource usage <BR>2. The capacity and performance of your already zipy application would increace noticably. <BLOCKQUOTE TYPE=CITE> <P>> All it <BR>> takes is one well <BR>> trained DBA/App Developer to come by and make it go 20x faster to really <BR>> embaras someone. <P>Now, you've got it. The question of database design and development can't <BR>be answered by focusing on only lock strategies. Yes, they're important, <BR>but only part of the picture. And database tuning is a multi-faceted <BR>discipline.</BLOCKQUOTE> Good point. If I could add to that with some of my own anecdotal experiance, The presence of RLL often suggests to me that the project is being managed by VB programmers. Not that I have anything against VB, but it is all too often used as a development tool by the inexperienced programmer. While cleaning up the RLL in this case might cure some of the performance bottleknecks, there are bound to be scads of other problems in the design that weigh it down. <BLOCKQUOTE TYPE=CITE> <P>> <BR>> Christopher Browne wrote: <BR>> <BR>> > >Generaly speaking, row-level-locking is regarded to be a design flaw <BR>> > >anyway, so you probably don't want to rate that feature too highly. <P>I'm curious, by whom? Certainly not Oracle corp. <BR> </BLOCKQUOTE> Duh! [sais the Oracle marketing department] <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>; </HTML> --------------BA9AF6686A493C3698498840--