Re: UTF8 Vs. WE1252 performance

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Wed, 28 Sep 2011 16:51:47 -0700 (PDT)
Message-ID: <1317253907.59694.YahooMailNeo_at_web65404.mail.ac4.yahoo.com>

We're running a 3-node RAC with AL32UTF8 as the characterset and we experience no performance issues related to the character set definition.

David Fitzjarrell

From: Raju Angani <angani_at_gmail.com>
To: oracle-l_at_freelists.org
Sent: Wednesday, September 28, 2011 4:41 PM Subject: UTF8 Vs. WE1252 performance

Hi Oracle gurus,

Firstly, big thanks to Kyle, Mark & Jared for taking care of the post privilege issue.

Jumping straight at the performance question, currently on one of the applications, I'm using WE8MSWIN1252 characterset and using 916 NVARCHAR2 columns of the total 2880 columns in the schema(282 tables). I'm recommending to create the DB with UTF8 characerset and switch all 916 NVARCHAR2 to VARCAR2 within the schema and expand the column length to accommidate the multibyte characters, to take care of truncation issues with CS change.

Question: What would be the performance impact(good/bad)? Using utf8 in the past, performance was slightly low when doing string comparison.

Could you please share your experience or any pointers.

Thank you
Raju
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 28 2011 - 18:51:47 CDT