Re: Any optimization hints for AT&T StarServer E, Informix SE?

Posted in 1994

Ron Delpiere-Smith — 10 Nov 94 16:21:25 GMT — source: Informix-list mailing list archive (1991-1998)

shwake@nearside.UUCP (Raymond Shwake) writes: > I know I should be getting more out of the box, perhaps by tweaking >the operating system or Informix. Perhaps those who have succeeded with such >optimization could describe just what they did to fully exploit the box. Raymond: Not much available in the way of tuning Standard Engine (SE). The best that maybe you could hope for is to SET EXPLAIN ON, and check to see if you are doing any sequential scans of your tables. The only other option that you may have is to split up you database across multiple hard drives. (Some tables on drive 1 some on drive 2 ...) Good Luck Ron Delpiere-Smith reds@informix.com