Received: from fw.mccons.net (adsl-65-64-105-41.dsl.kscymo.swbell.net [65.64.105.41]) by postgresql.org (Postfix) with ESMTP id 963FF475B66 for ; Tue, 26 Feb 2002 04:39:16 -0500 (EST) Received: (from root@localhost) by fw.mccons.net (8.11.3/8.11.4) id g1Q9dH921182 for pgsql-admin@postgresql.org; Tue, 26 Feb 2002 03:39:17 -0600 (CST) (envelope-from bmccane@mccons.net) Received: from localhost (localhost [127.0.0.1]) by fw.mccons.net (8.11.3/8.11.4av) with ESMTP id g1Q9dAH21171 for ; Tue, 26 Feb 2002 03:39:11 -0600 (CST) (envelope-from bmccane@mccons.net) Date: Tue, 26 Feb 2002 03:39:10 -0600 (CST) From: Brian McCane To: pg-admin Subject: Performance question In-Reply-To: <1014713640.785.15.camel@klingon> Message-ID: <20020226033228.B17694-100000@fw.mccons.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS perl-11 X-Archive-Number: 200202/348 X-Sequence-Number: 3501 First of all, I have somewhat fixed my locking problems from before, at least to the point that the app is mostly usable. I will tweak it more later, when I have some more free time to myself :) Now: I use an english alphabet exclusively in an app I am working on for another customer. If I need to put non-english characters, I use the HTML encoding functions from HTML::Entities in Perl. This causes me to store strings like: You’re antique vase cost ¥5.000.000 Okay, you get the picture any way. Since I am using a strict alphabet like this, would it be faster to build PostgreSQL without Multibyte support? Or has the indexing, etc. been optimized so much for multibyte that it is actually faster than single byte stuff? - brian Wm. Brian McCane | Life is full of doors that won't open Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those Usenet http://freenews.maxbaud.net/ | that open when you don't want them to. Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"