Performance question

From: Brian McCane <bmccane(at)mccons(dot)net>
To: pg-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Performance question
Date: 2002-02-26 09:39:10
Message-ID: 20020226033228.B17694-100000@fw.mccons.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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&#146;re antique vase cost &yen;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"

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Michel POURE 2002-02-26 10:56:15 Re: problems with PgAdmin and database encoding.
Previous Message Manuel Trujillo 2002-02-26 08:54:00 problems with PgAdmin and database encoding.