From our performance measurement, data size is the bottle neck for performance
in database application as majority of operation is to insert, update, and
data. If most of your information in your database is English and W. European
characters, it is better to use UTF-8 as database encoding as it will take less
space than UCS2/UTF-16, which will give your better performance.
Michael Kung wrote:
> Yes, it could. If you are using the UTF-8 database w/ European characters,
> you are not just expanding the size to 2 but you also carry the DBCS-like
> performance hit to parse the data string (one or 2 bytes). Yet, if you use
> the sorted index feature in database, the overhead of sorting Unicode level
> is there as well.
> If you are using SQL Server, choose binary sort on Unicode is the best
> performance choice.
> -----Original Message-----
> From: Marco.Cimarosti@icl.com [mailto:Marco.Cimarosti@icl.com]
> Sent: Friday, September 22, 2000 2:11 AM
> To: Unicode List
> Cc: email@example.com
> Subject: FWD: Unicode on a website
> Hi, Santosh.
> I am forwarding your questions to the Unicode List, as there are many people
> there that know much more than me about web programming and databases.
> What I can say, is that I don't see how Unicode could have any noticeable
> impact on the performance of a web site: after all it is just a "character
> The only difference will be in the number of bytes needed for the text part
> of the web site: Unicode often (but not always!) requires more bytes that
> other encodings.
> But this should have really little influence on performance, if you consider
> that plain text should be a relatively a small part of the total information
> in a typical web site, which also contains pictures, Java applets, CSS,
> > -----Original Message-----
> > From: Santosh.S.N [mailto:firstname.lastname@example.org]
> > Sent: 21 Sep 2000, Thu 12.29
> > To: Marco.Cimarosti@icl.com
> > Subject: Unicode on a website
> > Hi,
> > I would like to have some information from you
> > regarding the utility of
> > unicode in a website.
> > That is to say that I would like to know if you have a
> > website that uses
> > unicode, how its performance is and other such details.
> > To be more precise I would like to know the performance of
> > any website
> > which is working on unicode.(i.e. How unicode enhances or degrades the
> > performance of a website depending on the data retrieval speed etc.)
> > I would be very grateful to you if you could please get back
> > to me on this
> > one.
> > Santosh.S.N
> > MTS,Priceline
> > HCL Technologies
> > Ph-(0118)-4516317/...324 extn.1062 (O)
> > email@example.com
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:13 EDT