Database tuning.. any hints?
Posted in 1994
Topics: Performance & Tuning
I'm very new to Informix and I'm trying to improve performance for an Informix application we are running. The application is Quintus and each process is consuming about 10 megs of virtual memory on an HP 9000 server. Of the 10 megs about 6meg is private data. Also the tbstat -p program reports about a 95-97% cache hit rate on reads but less than 20% on writes.. I have BUFFERS set at 1000, LOCKS is about the same, and the clean MIN/MAX values (can't remember the parameter names) are 70 and 80.. I've made a few changes as suggested by the ref manual tuning section and gotten some improvement. Can anyone suggest anything I can do. Do I need to provide more info about my tbconfig settings? Thanks in advance for any help. -- -------------------+----------------------------------------------------------- finger for PGP key | "Thufir, old friend," Paul said, "as you can see my back | is to no door." jockc@netcom.com | "The universe is full of doors," Hawat said.