Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EB19B64FDDF for ; Tue, 14 Oct 2008 19:35:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54832-01 for ; Tue, 14 Oct 2008 19:35:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.188]) by postgresql.org (Postfix) with ESMTP id 5728964FDFB for ; Tue, 14 Oct 2008 19:35:39 -0300 (ADT) Received: by ti-out-0910.google.com with SMTP id y8so1382320tia.5 for ; Tue, 14 Oct 2008 15:35:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=uGGt4b1+xYesxlgPTEaoKXtK1nuMvoYgcU2jWT04PSU=; b=xRbH5kis4DS0QyZjE50THHJ9Frqe9NafgP60RetjSKK2/ZYbo+Iai9KBphXtEZqLeT 6+cGF2t2LpRGQSCo/cl/QGqd3Y1JEWT6vMOaga9hIy/5//GCfuraQ1zpQqQy7Oktx1cs nRTFftD1EBaKz5z6lmzJSnCl4q5UZtX1uri9k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=UE3fLVz/XUZqXQ4gfrbIG2zqyoLo0l610AuseHL6v8Jtl12FG3sVpXoleIQdwwxyLA k1LN5pnztjcESr5Az/69CTeGkcobqBsg9N4oyVA3Pc7eHV7HTwVFdgDH8PUZPDB9WXlp VMbuQkiyQB17tt69SyHRHodE3u2cAJ8KjjONc= Received: by 10.110.57.6 with SMTP id f6mr85909tia.46.1224023736974; Tue, 14 Oct 2008 15:35:36 -0700 (PDT) Received: from ?192.168.0.70? (office.squiz.net [203.206.128.174]) by mx.google.com with ESMTPS id w12sm1880780tib.10.2008.10.14.15.35.35 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 14 Oct 2008 15:35:36 -0700 (PDT) Message-ID: <48F51EB4.3090908@gmail.com> Date: Wed, 15 Oct 2008 09:35:32 +1100 From: Chris User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: Ang Chin Han CC: pgsql-general@postgresql.org Subject: Re: Drupal and PostgreSQL - performance issues? References: <2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org> <200810122214.53558.uwe@oss4u.com> <20081013090228.248a665f@dawn.webthatworks.it> <20081014114011.0ebe495a@dawn.webthatworks.it> <8c8854360810140647n58abc9bend377e0e234dd39a9@mail.gmail.com> <8c8854360810140828p3b81bba0xac006f5565519981@mail.gmail.com> In-Reply-To: <8c8854360810140828p3b81bba0xac006f5565519981@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/580 X-Sequence-Number: 138829 > Note this comment: > /* > * Queries sent to Drupal should wrap all table names in curly brackets. This > * function searches for this syntax and adds Drupal's table prefix to all > * tables, allowing Drupal to coexist with other systems in the same database if > * necessary. > */ > That's an MySQL-ism for working around legacy hosting sites offering > only a single MySQL db bogging postgresql down... No it's not. It's about being able to use a single db for multiple app's. Either I do something like that, or I have to [hardcode] change schemas after each connection because I only have a single db & a single db user.. which postgres/oracle[I'm sure others] support but not mysql. Shared hosts don't give you a lot of resources, so apps build stuff like that in to make it easier. -- Postgresql & php tutorials http://www.designmagick.com/