Re: Bad performance because of wrong characterset?

At 10:34 17-11-03 -0800, you wrote:

>Performance depends on a lot of things, such how much string operations you
>got, what are the contents of your strings (are they mainly latin chars or
>are there lots of asian ones etc..).
>
>Tanel.

Thanks Tanel for your respond. I doubt whether a query will go from several minutes to seconds, even when a fixed-width single-byte characterset is chosen. I'm not supposed to interfere with this Service Desk project, but just couldn't keep my mouth shut when I heard HP scheduled a meeting for tomorrow (when I'm not there) and claimed that recreation of a database with the proper characterset would do the job. I suggested to do some tracing & analysis first, before start shooting at a moving target in the dark. And of course posted the question to this bunch of knowledgable people.

Regards, Carel-Jan

• There will allwasy be another 10 last bugs --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan
  INET: cjpengel.dbalert_at_xs4all.nl

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).