1.3.0 to 1.4.0 cause only partial albums, pictures, comments to be displayed

[itang]

Hi everybody, got a problem.

What i have done:
1. 2 server, one web server, one mysql server.
2. update web server to Centos5, keep old mysql server as redhat 9 with mysql 3.23.
3. update 1.3.0 to 1.4.10, use the old mysql server as database server.
4. do not use utf8 as default language because the database is in big5.
5. Everything is fine but the performance of mysql is slow, very slow, always 99.9 precent CPU usage.
6. Mysql server is Dual p3 866 2G ram 9GSCSI hard disk x 2 as Raid 1.

What i done to move the database:
1.Mysqldump cpg database and import to new web server which runs mysql 5.0.
2.keep character set as latin1.
3.database is good big5 character set beacuse it can be read under phpmyadmin with big5 encoding.

The problem (For guests or register users):
1. At the last upload album for all users, only about a hundred pictures can be shown.
2. Only some of the album for a user can be shown.
3. Click on one's album but it display no image to display.
4. No comment can be shown.

In conclusion, that is some of the information from the database is not correctly shown.

However, when I log in as admin, all the problem gone. All the albums, pictures, comments can be shown correctly.

Can anyone give me some hints to solve this problem. Where should I look into? Thanks for your kind attention.

P.S. I cannot use UTF8, have tried to convert the utf8 but the same problem occure. Another problem is that some the picture's file name is in big5, utf8 just don't work.