Return-Path: X-Original-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 25B8F6708 for ; Sun, 31 Jul 2011 23:14:56 +0000 (UTC) Received: (qmail 27315 invoked by uid 500); 31 Jul 2011 23:14:55 -0000 Delivered-To: apmail-incubator-ooo-dev-archive@incubator.apache.org Received: (qmail 27260 invoked by uid 500); 31 Jul 2011 23:14:55 -0000 Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-dev@incubator.apache.org Delivered-To: mailing list ooo-dev@incubator.apache.org Received: (qmail 27251 invoked by uid 99); 31 Jul 2011 23:14:55 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 31 Jul 2011 23:14:55 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [94.136.40.61] (HELO mailex.mailcore.me) (94.136.40.61) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 31 Jul 2011 23:14:45 +0000 Received: from host86-129-247-134.range86-129.btcentralplus.com ([86.129.247.134] helo=[192.168.1.69]) by mail11.atlas.pipex.net with esmtpa (Exim 4.71) (envelope-from ) id 1QnfDF-0002JV-JO; Mon, 01 Aug 2011 00:14:25 +0100 Message-ID: <4E35E1D1.8090803@ellisons.org.uk> Date: Mon, 01 Aug 2011 00:14:25 +0100 From: TerryE User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.18) Gecko/20110617 Thunderbird/3.1.11 MIME-Version: 1.0 To: ooo-dev@incubator.apache.org CC: Wolf Halton Subject: Re: Questions: LAMP and PHPBB for OpenOffice.org References: <00c001cc4fc4$ca44e9c0$5ecebd40$@acm.org> <4E35D003.8090200@ellisons.org.uk> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Mailcore-Auth: 8445677 X-Mailcore-Domain: 884398 X-Virus-Checked: Checked by ClamAV on apache.org Hi Wolf, Long time, no speak. It would be good to catch up. On 31/07/11 23:15, Wolf Halton wrote: > Hi Terry, > Welcome to the party! > I have heard that database software runs less well on VMs and I am working > on developing a project using postgresql at work to test that. > Yup, but the main issue here is for I/O intensive apps, unless the virtualisation technology has accelerated I/O paths (for example VMware ESX does this). With the forums if the VM has a 2Gb or more then enough content is memory cached that I/O performance isn't really an issue whatever the VM technology. MediaWiki is a different story. It is D/B heavy. However, most of the current access is guest access so using a Squid or Varnish cache would drop the database I/O by a factory of up to 10 with current transaction patterns. We can work these issues. And yes, I can move back from MySQL to PostgreSQL as the forums used to run on this in the past, but its another task on the migration plan that I would prefer to avoid. Regards Terry