RE: A few questions

See some answers below. -----Original Message----- From: rico@wsx.wsex.com [mailto:rico@wsx.wsex.com] Sent: Thursday, April 22, 1999 1:17 PM To: informix-list@iiug.org Subject: A few questions Hello All, A few of questions: --- In 7.3 I see that after backing up old log files, they get marked U and B. In 5.0, I see that instead of marking the logs U (used), and B (backed-up), it marks them as F (free). Is this behavior normal, or is something wrong with my 7.3 instance. I am just wondering when those logs marked as U and B become F (free). They will not show an F anymore. But they are free and ready to be used when they have U and B. --- There is no USERS parameter in the onconfig file for 7.3. Does this mean that 7.3 has hardcoded limits for the # of users? The USERS parameter is gone but it is not hardcoded. It is dynamic. It is based on how much memory you have allocated to your instance. See the last line of onstat -u. Here's what one of mine looks like: 19 active, 128 total, 38 maximum concurrent It appears that I can only have 38 sessions, but that is not true. It will add another shared memory segment if need be and session 39 will be able to connect. --- I read a few posts a while back about the possibility of the optimizer being too slow to determine a query path. I believe it was on a 7.3X instance. My main question is, I myself have dissapointed by the raw speed of 7.3 vs 5.0, and is this a likely place to look for possible performance improvements? If so, is there anyway within 4gl RDS to code apps to minimize the length of time the optimizer evaluates its query plan possibilities? I'll let someone else answer this one. Dianne --- If I want to split high use tables across drives, what are some things that I should consider when deciding what goes where. Thanks in advance. Olaf