Performance hit with USEOSTIME = 1 on AIX?

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? Can anyone give me some real-world experience with IDS 9 on AIX 5 and USEOSTIME = 1? 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

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? > >Can anyone give me some real-world experience with IDS 9 on AIX 5 and USEOSTIME = 1? > >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 > > Consider, if you're doing inserts and selects with a program, using the system time() function in the C library. It returns a four byte integer representing the number of seconds since the UNIX epoch (which makes the arithmetic simple) and it's easy enough (in a program) to convert that value in a tm structure with the assortment of time functions in the C library; e.g., localtime(), difftime(), and so on. I've found the C functions to be much, much faster than the built-in Informix functions, particularly with ESQL/C, not so much with the push and pop routines in 4GL, at least where the operating system is Solaris 9. Might be worth a look.