Posting from the Informix-list
Posted in 1999
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). --- 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? --- 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? --- 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