Re: Performance hit with USEOSTIME = 1 on AIX?

Sean Baker wrote: > We're running IDS 9.40.FC4 on AIX 5.2. > > We would like to use DATETIME YEAR TO FRACTION(3) for a new application. I've searched through CDI and found several references to performance hits when you set USEOSTIME = 1, including the Informix docs (Admin Ref: 4 to 5 percent performance degradation). Others have said it depends on the OS. > > I'm assuming the performance hit is only when calling CURRENT, not a performance > hit to the server as a whole? I'm also wondering if it also effects > calls to TODAY, or if that still uses the internal Informix server time? The performance hit is normally minor. It depeneds on how good/bad the OS's implementation of gettimeofday() is. There are some OSes on which the impact will at least be noticed. > Can anyone give me some real-world experience with IDS 9 on AIX 5 and > USEOSTIME = 1? Art S. Kagel > Thanks, > > Sean. > - - - - > Sean Baker, Sr. Application Development Leader > Money Mailer, LLC > 14271 Corporate Drive > Garden Grove, CA 92843 > > 714.265.8288 ph > 714.265.8362 fax > > sending to informix-list

BENCHMARK...BENCHMARK..BENCHMARK..BENCHMARK... We don't run your app so you'll need to benchmark it yourself.