Re: USEOSTIME and performance

In article <34EAD1EA.218B@mcmail.com>, Paul Watson <watson@mcmail.com> writes >I have been asked to check the performance differences between USEOSTIME >on and off. I expected the that there would be a slightly better >performance (4-5% according to manual) with USEOSTIME = 0/No. This >isn't the case on the tests done, in fact it is exactly the reverse. >With USEOSTIME set to 1/Yes it is consistently better by 4-5%. > >The test script is a simple insert into a temp table, no time >information used. > Try using something that needs time. 1. USEOSTIME=NO Online handles it internally. Hence some work is done every second. Proably an alarm 1 and gettimeofday? 2. USEOSTIME=YES Online calls the OS every time the time is required. Hence some work is done every time the time is needed. I expect 1 has some internal overhead even if the time is not used and 2 has less overhed if the time is needed more than once in a given second. Try it inserting rows that need the time. >Anybody care to comment, or spot something I've missed > >BTW Online DSA 7.12/AIX 3.2.something > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care