Re: Converting tables to Unicode Coded Character Set Identifier

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Kevin,

How do you retrieve your record? I wouldn't expect the character
conversion to add much overhead. From your description it seems more
likely that you are getting a new connection for every record. Do you
have a profiler like JProbe? That can really help isolate where the time
is being spent.

David Morris

>>> Kevin_J_Forster@xxxxxxxxxxxxxxx 9/26/2004 11:03:47 PM >>>




I am in the process of developing a process on a iSeries that consists
of a
ILE RPG extract, and a Java consumer. At the moment the Java component
is
taking 2 seconds to process a transaction. Which, is not acceptable.
One of
the IBM JDBC performance recommendations, from the Web site, is to
convert
the tables to Unicode CCSID.

I know that one side affect of the Unicode CCSID is that it requires
two
bytes per character. Which means increased DASD, and more data being
sent
to the remote system (where the Java component resides).

Can someone tell me, in detail, what it will mean to my ILE RPG extract
?


Regards
Kevin Forster
This email is sent by or on behalf of the named sender identified
above. If
you do not wish to receive any email marketing material from this
person in
the future, please forward the contents of this email to
unsubscriptions@xxxxxxxxxxxxxxx with the word "unsubscribe" in the
subject
box. If you do not forward the contents of this email with your
unsubscription then it may not be able to be implemented.  If you wish
to
unsubscribe from all central email marketing lists used by our
business,
please forward the contents of this email to
unsubscriptions@xxxxxxxxxxxxxxx with the message "unsubscribe from all
central email marketing lists" in the subject box.  If you do not
forward
the contents of this email with your unsubscription then it may not be
able
to be implemented.


The information contained in this email communication may be
confidential.
You should only disclose, re-transmit, copy, distribute, act in
reliance on
or commercialise the information if you are authorised to do so.  Any
views
expressed in this email communication are those of the individual
sender,
except where the sender specifically states them to be the views of a
member of the National Australia Bank Group of companies.  Any advice
contained in this e-mail has been prepared without taking into account
your
objectives, financial situation or needs. Before acting on any advice
in
this e-mail, National Australia Bank Limited recommends that you
consider
whether it is appropriate for your circumstances. If this e-mail
contains
reference to any financial products, the National recommends you
consider
the Product Disclosure Statement (PDS) or other disclosure document 
before
making any decisions regarding any products.  The National Australia
Bank
Group of companies does not represent, warrant or guarantee that the
integrity of this communication has been maintained nor that the
communication is free of errors, virus or interference.