X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5773B11F6266 for ; Wed, 29 Mar 2006 23:11:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81440-02 for ; Wed, 29 Mar 2006 23:11:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tomts27-srv.bellnexxia.net (tomts27-srv.bellnexxia.net [209.226.175.101]) by postgresql.org (Postfix) with ESMTP id D10B811F6552 for ; Wed, 29 Mar 2006 23:11:27 -0400 (AST) Received: from mail.oghma.on.ca ([69.159.214.132]) by tomts27-srv.bellnexxia.net (InterMail vM.5.01.06.13 201-253-122-130-113-20050324) with SMTP id <20060330031127.JTRM27598.tomts27-srv.bellnexxia.net@mail.oghma.on.ca> for ; Wed, 29 Mar 2006 22:11:27 -0500 Received: (aITmail 8626 invoked by uid 8); 30 Mar 2006 03:11:16 -0000 Received: from lancelot.oghma.on.ca (listsubscriptions@oghma.on.ca@172.16.6.37) by uther.oghma.on.a with SMTP; 30 Mar 2006 03:11:16 -0000 From: Gorshkov Organization: Oghma Systems To: pgsql-performance@postgresql.org Subject: Re: Decide between Postgresql and Mysql (help of Date: Wed, 29 Mar 2006 23:39:46 -0500 User-Agent: KMail/1.7 References: <1143559902.1241.16.camel@servidor> <200603292307.29034.listsubscriptions@oghma.on.ca> <442B4A06.8060900@modgraph-usa.com> In-Reply-To: <442B4A06.8060900@modgraph-usa.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603292339.46415.listsubscriptions@oghma.on.ca> X-ORIGINAL-HEADER: Received: (aITmail 8626 invoked by uid 8); 30 Mar 2006 03:11:16 -0000 X-ORIGINAL-HEADER: Received: from lancelot.oghma.on.ca (listsubscriptions@oghma.on.ca@172.16.6.37) X-ORIGINAL-HEADER: by uther.oghma.on.a with SMTP; 30 Mar 2006 03:11:16 -0000 X-ORIGINAL-HEADER: From: Gorshkov X-ORIGINAL-HEADER: Organization: Oghma Systems X-ORIGINAL-HEADER: To: pgsql-performance@postgresql.org X-ORIGINAL-HEADER: Subject: Re: [PERFORM] Decide between Postgresql and Mysql (help of X-ORIGINAL-HEADER: Date: Wed, 29 Mar 2006 23:39:46 -0500 X-ORIGINAL-HEADER: User-Agent: KMail/1.7 X-ORIGINAL-HEADER: References: <1143559902.1241.16.camel@servidor> <200603292307.29034.listsubscriptions@oghma.on.ca> <442B4A06.8060900@modgraph-usa.com> X-ORIGINAL-HEADER: In-Reply-To: <442B4A06.8060900@modgraph-usa.com> X-ORIGINAL-HEADER: MIME-Version: 1.0 X-ORIGINAL-HEADER: Content-Type: text/plain; X-ORIGINAL-HEADER: charset="iso-8859-1" X-ORIGINAL-HEADER: Content-Transfer-Encoding: 7bit X-ORIGINAL-HEADER: Content-Disposition: inline X-ORIGINAL-HEADER: Message-Id: <200603292339.46415.listsubscriptions@oghma.on.ca> X-RECEIPT-TO[0]: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.051 required=5 tests=[AWL=0.051] X-Spam-Score: 0.051 X-Spam-Level: X-Archive-Number: 200603/599 X-Sequence-Number: 18036 On Wednesday 29 March 2006 22:01, Craig A. James wrote: > This is off-topic for this group so I'll just give a brief reply; I'm happy > to carry on more just between the two of us... > > Gorshkov wrote: > > That being said ..... what *is* the difference between coding a website - > > major or otherwise - in an "old-fashioned" compiled language and a > > non-compiled language, except for the amount of hoursepower and memory > > you require? > > > > Old-fashioned doesn't mean bad, inappropriate, or inferior. It's just not > > the latest-and-greatest, however it's currently defined by the geek > > fashion police. > > Our experience coding web sites with C/C++ versus Perl is about a factor of > ten in productivity. We only use C/C++ for CPU-intensive calculations, > such as scientific prediction code. Everything else is Perl or Java. > > I recently re-coded 10,000 lines of C into 650 lines of Perl. Why? String > handling, hash tables, and the simplicity of DBD/DBI. And there was no > loss of performance, because the app was strictly I/O bound (that is, > Postgres was I/O bound). Sure, the old app may not have been optimal, but > we're talking about a factor of 15 reduction in lines of code. Sounds to me like the C programmers in your past needed to learn how to re-use code and make libraries. That's not a function of the language - that's a function of the programmer. > > That's not "geek fashion", it's good engineering. Pick the best tool for > the job, and learn how to use it. > Thanks for making my point. You choose the best tool for the job, and sometimes it's "old-fashioned". Please remember that - there may be newbies out there who think that if they're not using the latest alpha-beta-zeta version .0006-a-r1, then they must be bad programmers.