Performance Problems after migration to AL32UTF8 | Bugs, Issues and Errors | Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

—  Results per page  —








— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters
For a group of consecutive words like 'end of support' use Match phrase

sp_Feed Topic RSS sp_TopicIcon
Performance Problems after migration to AL32UTF8
15 Jun 2018
12:15 pm
Avatar
Hendrik Schmidt
Member
Forum Posts: 11
Member Since:
24 Feb 2017
sp_UserOfflineSmall Offline

Hello,

we have Uniface 9.7.0.4.x and Oracle DB 12.1.0.2.

we migrated the database characterset from WE8ISO8859P15 to AL32UTF8 using Oracle’s DMU ( Database Migration Assistant for Unicode).

We set in the ASN’s

$DEF_CHARSET = utf8

$SYS_CHARSET = utf8

$WIDE_CHAR_BEHAVIOR = Unicode

we changed in the repository the character field Definition from Cxxx or C* to Wxxxx or W* or U*  and MUL to FUL

eg:

update fare.ucfield set u_intf = replace(u_intf, ‘C’, ‘W’) where u_vlab = ‘MR’ and u_dtyp = ‘S’ and u_intf like ‘C%’ and u_flab <> ‘U_VERSION’;

update fare.ucfield set u_syn = replace(u_syn, ‘MUL’, ‘FUL’) where u_vlab = ‘MR’ and u_syn like ‘%MUL%’; commit; -> 1661 Zeilen aktualisiert.

update fare.uxfield set INTERFACEMOD = replace(INTERFACEMOD, ‘C’, ‘W’) where ubase = ‘MR’ and INTERFACEMOD like ‘C%’; -> 5916 Zeilen aktualisiert.

update fare.uxfield set SYNTAXMOD = replace(SYNTAXMOD, ‘MUL’, ‘FUL’) where ubase = ‘MR’ and SYNTAXMOD like ‘%MUL%’; -> 3486 Zeilen aktualisiert.

We recompiled whole Application

We can insert/save/query Unicode characters eg: Ҹҵ

but the Performance is very bad. It seems that the Display / Rendering of Formsmasks is very slow ( ~ 5 tims slower as before)

eg. we have normally a save and commit button in the masks -> if we press it, the save comes very fast, but to go back to the previous mask and display it, it needs very long.

Any ideas? Someone know this Situation?

many thanks in advanced

Hendrik

05 Jul 2018
12:24 pm
Avatar
jverdugocall
Member
Forum Posts: 8
Member Since:
22 May 2017
sp_UserOfflineSmall Offline

Hello Hendrik,

I was just about to write a similar problem and I saw your post.

We migrated our application from Uniface 9.6.08 to 9.7.04 and detected that a screen that was being opened immediately now takes about 6-7 seconds to be opened. Debugging we have seen that it occurs also when the screen is drawn through the command Display in the form. Nothing has changed in the database configuration or model.

Any ideas? Did you solve the problem?

Thanks in advance and regards,

José Manuel

05 Jul 2018
3:34 pm
Avatar
Knut
Member
Forum Posts: 214
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi,

I generally try to use this tool when I get into some perfomance issues since all process info related to the Uniface process
will be trapped;

https://docs.microsoft.com/en-us/sysinternals/downloads/procmon

Also, you didn’t say anyting about the Oracle driver you’re using as well as the Oracle client…
I’ve had instances in the past where there was a version mis-match between either the Uniface driver (rare)
or the DBMS client sw.

Knut

06 Jul 2018
4:52 pm
Avatar
PBeugel
Member
Forum Posts: 33
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hello Hendrik

Have you tried the connector option uselike from the Uniface driver for Oracle:
Use
Use uselike
only if you encounter performance problems when working with Unicode data and the database is set up with Unicode character sets (UTF8, UTF16, and so on), because
LIKE calculates strings using characters as defined by the input character set.

Description
By default, the connector invokes the Oracle LIKEC operator when the where clause is used in SQL queries with Unicode data
($DEF_CHARSET =UTF8 or when the field has a W interface).
In some configurations, this may lead to performance problems.

 

We introduced because likec from Oracle has performance  issues

Peter

Kind regards Peter Beugel Sr. Technical Support Analyst Uniface B.V.
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online: Iain Sharp, tommyb42
24 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1788

Iain Sharp: 654

Theo Neeskens: 357

gianni: 312

rogerw: 261

istiller: 252

Knut: 214

lalitpct: 197

Arjen van Vliet: 175

sochaz: 173

Member Stats:

Guest Posters: 3

Members: 8917

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2206

Posts: 9539

Newest Members:

EddieUrict, Waltershago, Phyllisvar, Calvindax, RobinMarttensss, rickqo3, Henryexham, MichaelSew, EROnedieby, christinalf3

Administrators: admin: 23, Adrian Gosbell: 318, diseli: 967, Bob Maier: 3, Nico Peereboom: 77, Michael Rabone: 4, richiet: 406, JanCees: 29