Re: SE 5 tuning/optimizing on SCO

Hi All Thanx for all the replies. Sorry for the HTML. My first time posting to the list. 8-) Hmmm you say only 10 users. Is there a set formula for calculating the amount of ram per user? We are running 2 applications on the one server. A financial tool Maestro (old clone of Chameleon) where 60% of my users work on, and then a in-house developed 4gl application. Number of users +-20 to 25 at a time. Thus about 10 working on the 4gl application. I can't do much about Maestro as it is a 3 party application, but it does draw on the server resources. Updating of products is out of the question,as we are a nonprofit org. thus money is hard to come by and I need to squeeze every last bit of power out of these dinosaurs. I think the high %wio is caused due to a few factors. I have put in a request for more memory, but I think it is the amount of data being reported on that is killing the server. Our larges tables (and most accessed) are: 19723264 qb_do00593.dat Row Size 364 Number of Rows 54035 Number of Columns 33 I can't drop and recreate this table due to the fact that it contains a serial that is reference in other tables. (or have I been wrongly informed?) 9304064 qb_tr00609.dat Row Size 33 Number of Rows 273646 Number of Columns 8 I have dropped an recreated this one a few months ago. The searches are done via date fields (between start and end), integer fields (doc number) and a char string (org number char10). All these fields are indexed. I think the order by clauses are the biggest culprits. Any other idees. I know that in online you can tune your locks, buffers etc. Are there any thing in SE that I can modify? sar -r reports (all Greek to me): 09:44:14 freemem freeswp availrmem availsmem (-r) 09:44:17 34095 389120 44837 81739 09:44:20 34095 389120 44837 81738 09:44:23 34093 389120 44837 81737 Average 34094 389120 44837 81738 Cheers Franz sending to informix-list