Re: Multibyte or not?

Chantal,

If you are using the 7.2 jdbc driver, you would only need to have
multibyte support compiled into the server if you wanted to store
multibyte characters.

--Barry

Chantal Ackermann wrote:
> Hello all,
>
> at the mysql-admin list I found a posting that says a non-multibyte built of
> the database would be faster than a multibyte one. My question is - do I
> always need a multibyte built if I plan to access the db with jdbc or do i
> only need it if the data is non-ascii? i know that java uses unicode but does
> that really matter unless I want to enter non-ascii letters?
>
> actually this came to my mind when I was in search for some tuning hints. I
> don't think this is the right place to ask this (would 'psql-admin' be that?)
> - but maybe one of you had similar problems?
> I am doing a lot of checking and inserting at runtime. while the java thread
> holds ~38Mb (~500Mb) it uses only 1.7% CPU (~900Hz). postgresql uses less
> than 4Mb at more than 90% CPU. I already doubled the effective cache size to
> be '2000' but that did not change anything.
>
> I wonder if the postgres would be faster if it would use more RAM. or is this
> the bottle neck's end (unless I get a better CPU)?
>
> thank you
> Chantal
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>