Oninit cdi / Archive
Talk to an expert →

Re: Where are the fractions of a second of CURRENT?

Posted in 2004

Topics: Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life

Jesus Antonio Santos Giraldo — — source: Usenet: comp.databases.informix

Yea it works, tahnks. Although in onconfig.log it shows: # method for OnLine to use when determining current time USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow) It is worth to use USEOSTIME 1? Jean Sagi wrote: > Ummmm... > > There is a _severe_ performace penalty if our DBA do this? > > Chucho! > > > -----Original Message----- > From: "Everett Mills" <eemills@nationalbeef.com> > To: <informix-list@iiug.org> > Date: Fri, 24 Sep 2004 16:54:35 -0500 > Subject: RE: Where are the fractions of a second of CURRENT? > > Jean- > You need to have: > > USOSTIME 1 > > set in your onconfig. Otherwise Informix only updates the time once a second. > > --EEM > > >>-----Original Message----- >>From: Jean Sagi [mailto:jeansagi@myrealbox.com] >>Sent: Friday, September 24, 2004 4:11 PM >>To: informix-list@iiug.org; jeansagi@myrealbox.com >>Subject: Where are the fractions of a second of CURRENT? >> >> >>I haven't seen this before, but when in dbaccess I issue: >> >>select current >>from dual>>; >> >>Informix returns: >> >>ct >>----------------------- >>2004-09-24 16:06:37.000 >> >> 1 row(s) retrieved. >> >>I keep the RUN option (holding R pressed) and I see how the second pass >>but I don't see the fractions of the second... >> >>Why? >> >>If I issue: >> >>select extend(current, year to fraction(5)) ct >>from table( set{1} ) >> >>Yet no joy: >> >>ct >>------------------------- >>2004-09-24 16:09:14.00000 >> >>Really interesting? >> >>- Maybe is a disabled option? >>- it's dbaccess? (Although Winsql shows the same behavior). >>- It's the engine >> >> >>Rigth know I'm using >> - IDS 9.30.HC2W8 >> - HP-UX ipsilon B.11.00 >> >>Any hint would be very appreciated. >> >> >>Chucho! >> >>Jean Sagi >>jeansagi@myrealbox.com >>jeansagi@yahoo.com >> >>sending to informix-list > > > sending to informix-list > > > Jean Sagi > jeansagi@myrealbox.com > jeansagi@yahoo.com > > sending to informix-list > sending to informix-list

↪ replying to Jesus Antonio Santos Giraldo
Madison Pruet — — source: Usenet: comp.databases.informix

It depends on the OS. Some OS make a light-weight function which returns the current machine time in ms. Others have to go deep into the kernel to get it. The USOSTIME 0 is rather fast because we keep the time in seconds at a fixed memory location in shared memory. However, for other items, it is a bit more expensive because we get the time when the query execution begins instead of just once a second. "Jesus Antonio Santos Giraldo" <jeansagi@myrealbox.com> wrote in message news:cj32b6$r6a$1@news.xmission.com... > > Yea it works, tahnks. > > Although in onconfig.log it shows: > > # method for OnLine to use when determining current time > USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow)> > It is worth to use USEOSTIME 1? > > Jean Sagi wrote: > > Ummmm... > > > > There is a _severe_ performace penalty if our DBA do this? > > > > Chucho! > > > > > > -----Original Message----- > > From: "Everett Mills" <eemills@nationalbeef.com> > > To: <informix-list@iiug.org> > > Date: Fri, 24 Sep 2004 16:54:35 -0500 > > Subject: RE: Where are the fractions of a second of CURRENT? > > > > Jean- > > You need to have: > > > > USOSTIME 1 > > > > set in your onconfig. Otherwise Informix only updates the time once a second. > > > > --EEM > > > > > >>-----Original Message----- > >>From: Jean Sagi [mailto:jeansagi@myrealbox.com] > >>Sent: Friday, September 24, 2004 4:11 PM > >>To: informix-list@iiug.org; jeansagi@myrealbox.com > >>Subject: Where are the fractions of a second of CURRENT? > >> > >> > >>I haven't seen this before, but when in dbaccess I issue: > >> > >>select current > >>from dual> >>; > >> > >>Informix returns: > >> > >>ct > >>----------------------- > >>2004-09-24 16:06:37.000 > >> > >> 1 row(s) retrieved. > >> > >>I keep the RUN option (holding R pressed) and I see how the second pass > >>but I don't see the fractions of the second... > >> > >>Why? > >> > >>If I issue: > >> > >>select extend(current, year to fraction(5)) ct > >>from table( set{1} ) > >> > >>Yet no joy: > >> > >>ct > >>------------------------- > >>2004-09-24 16:09:14.00000 > >> > >>Really interesting? > >> > >>- Maybe is a disabled option? > >>- it's dbaccess? (Although Winsql shows the same behavior). > >>- It's the engine > >> > >> > >>Rigth know I'm using > >> - IDS 9.30.HC2W8 > >> - HP-UX ipsilon B.11.00 > >> > >>Any hint would be very appreciated. > >> > >> > >>Chucho! > >> > >>Jean Sagi > >>jeansagi@myrealbox.com > >>jeansagi@yahoo.com > >> > >>sending to informix-list > > > > > > sending to informix-list > > > > > > Jean Sagi > > jeansagi@myrealbox.com > > jeansagi@yahoo.com > > > > sending to informix-list > > > > sending to informix-list

Glossary