RE: Performance Problems

Paulo, I remember having read is this NG some time ago, that using NCHAR causes some performance problems. I do not recall specifics. Maybe you can search old postings. Hope this helps Tino > > > Paulo Amorim wrote: > > > Hello again... > > > > We're using IDS 7.30.UC2 on an HP machine, D270 with 1 processor and > > 512 Mb RAM. > > > > There is only one instance up, wich have many databases. All databases > > were using the default GLS definitions, en_us.819. > > > > Due to a new developed system, built in 4J's, we had to convert one of > > the databases, so that the new database would be able to accept special > > characters. Then we exported the database and re-created it with > > pt_BR.819. The colums with data type char were re-created with data > > type nchar. > > > > All the configuration of the instance has not been changed, but since > > the creation of the new database, its performance has decreased too > > much. The processes are slowly than they were before. A simple select > > is taking much more time. The checkpoint time also was affected. The > > normal rate was 1-5 seconds, and now it's 6-15 seconds, with peaks of > > 30 seconds, even 60 seconds. > > > > I asked Informix Brasil if they'd seen something like this, and the > > answer was (obviously) no. They could not help. I wonder if someone has > > ever had this problem, or if somebody can give us some advice, because > > we don't know what happened. > > > > I'm attaching the onconfig file for this instance, I hope that someone > > can help us. > > > > Thanks in advance > > Paulo > >