Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1089578727.453289_at_yasure>...
> Michel Cadot wrote:
>
> > "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> a écrit dans le message de
> > news:ccr3ht$l16$1_at_sparta.btinternet.com...
> >
> >>This didn't reproduce on my 9.2.0.1.
> >>
> >> null operation: 174
> >> simple assignment 337
> >> double conversion 707
> >>
> >>
> >>
> >>--
> >>Regards
> >>
> >>Jonathan Lewis
> >>
> >
> >
> > It seems that my other didn't reach the group.
> > I repost it, sorry if it's double.
> >
> > I executed the following test with versions 8.1.7.4 and 9.2.0.4 on a WinNT4SP6 box:
> >
> > 9.2.0.4:
> >
> > n+15 -> 295
> > n+15.0 -> 227
> > c5=15 -> 732
> > c5=TO_CHAR -> 704
> > c5='15' -> 2929
> > c2='15' -> 2744
> > vc='15' -> 2749
> > c5=TO_CHAR(TO_NUMBER('15')) -> 821
> > -
> > n+15 -> 292
> > n+15.0 -> 214
> > c5=15 -> 727
> > c5=TO_CHAR -> 718
> > c5='15' -> 2930
> > c2='15' -> 2829
> > vc='15' -> 2764
> > c5=TO_CHAR(TO_NUMBER('15')) -> 827
> > -
> > n+15 -> 288
> > n+15.0 -> 213
> > c5=15 -> 737
> > c5=TO_CHAR -> 705
> > c5='15' -> 2959
> > c2='15' -> 2750
> > vc='15' -> 2751
> > c5=TO_CHAR(TO_NUMBER('15')) -> 823
> >
> >
> > 8.1.7.4:
> >
> > n+15 -> 309
> > n+15.0 -> 255
> > c5=15 -> 747
> > c5=TO_CHAR -> 1048
> > c5='15' -> 2610
> > c2='15' -> 2405
> > vc='15' -> 2388
> > c5=TO_CHAR(TO_NUMBER('15')) -> 1070
> > -
> > n+15 -> 303
> > n+15.0 -> 252
> > c5=15 -> 741
> > c5=TO_CHAR -> 1041
> > c5='15' -> 2618
> > c2='15' -> 3305
> > vc='15' -> 2400
> > c5=TO_CHAR(TO_NUMBER('15')) -> 1071
> > -
> > n+15 -> 305
> > n+15.0 -> 248
> > c5=15 -> 750
> > c5=TO_CHAR -> 1038
> > c5='15' -> 2615
> > c2='15' -> 2409
> > vc='15' -> 2404
> > c5=TO_CHAR(TO_NUMBER('15')) -> 1071
> >
> > The test case was:
> > DECLARE
> >
> > c5 CHAR(5);
> > i PLS_INTEGER;
> > j PLS_INTEGER;
> > n NUMBER := 0;
> > c2 CHAR(2);
> > vc VARCHAR2(5);
> >
> > BEGIN
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 1000000
> > LOOP
> > n := n + 15;
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('n+15 ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 1000000
> > LOOP
> > n := n+15.0;
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('n+15.0 ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 1000000
> > LOOP
> > c5 := 15;
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('c5=15 ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 1000000
> > LOOP
> > c5 := TO_CHAR(15);
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('c5=TO_CHAR ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 10000000
> > LOOP
> > c5 := '15';
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('c5=''15'' ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 10000000
> > LOOP
> > c2 := '15';
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('c2=''15'' ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 10000000
> > LOOP
> > vc := '15';
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('vc=''15'' ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > BEGIN
> > i := dbms_utility.get_time();
> >
> > FOR i IN 1 .. 1000000
> > LOOP
> > c5 := TO_CHAR(TO_NUMBER('15'));
> > END LOOP;
> >
> > j := dbms_utility.get_time() - i;
> > dbms_output.put_line('c5=TO_CHAR(TO_NUMBER(''15'')) ->' || TO_CHAR(j,'9999'));
> > END;
> >
> > END;
> > /
> >
> > --
> > Regards
> > Michel Cadot
>
> Thanks Michel and Jonathan. This has been very valuable.
>
> I am forwarding this thread to Francisco at Oracle.
>
> Daniel Morgan
As if they would care! PL/SQL days are := gone. END! learn a new language?!
Received on Mon Jul 12 2004 - 05:14:06 CDT
