Hi all,

re:
> DBPUTs to a small detail data set, linked to a single automatic
> master), showing count of number of PA-RISC instructions:
>
> without logging:                   with logging:
>
>                #Instructions                      #Instructions
>    KEY1 =>> 1   94856                KEY1 =>> 2       ?
>    KEY1 =>> 2   27490                KEY1 =>> 2       ?
>
>    KEY1 =>> 3   25482                KEY1 =>> 3   39325
>    KEY1 =>> 4   30293                KEY1 =>> 4   43217
>    KEY1 =>> 5   28837                KEY1 =>> 5   42718
>    KEY1 =>> 6   29975                KEY1 =>> 6   41916
>    KEY1 =>> 7   30978                KEY1 =>> 7   46193
>    KEY1 =>> 8   32545                KEY1 =>> 8   44951
>    KEY1 =>> 9   30530                KEY1 =>> 9   42214
>    KEY1 =>>10   92691                KEY1 =>>10  105428
>    KEY1 =>>11   10039 (full)         KEY1 =>>11   10426 (full)
>    ------------------                ------------------
>    Sum 3..11:  311370                Sum 3..11:  416388
>
> Ratio:  1.33      (Cost of dbputs 3..11  with/without)

Each DBPUT caused a new detail entry and a new master entry to be
allocated.  Schema:

   begin data base g01;
   passwords:
   items:
      key1           , x2;
      misc           , x2;
   sets:
   name: m1           , automatic;
      entry:
         key1              (1);
      capacity: 1000(3),10,10;
   name: d1           , detail;
      entry:                     <<4 bytes/entry>>
         key1         (! m1),
         misc;
      capacity: 10;
   end.


Measurement technique (requires user to have PM capability):

   :run querynm.pub.sys;debug

   b dbput,,, {s 1000000}
   b ?dbput + 8,,, {wl "# instructions: ", 1000000-rctr:"#"}
   c

   base=g01
   ;
   1

   add d1
   1
   1
   2
   2
   ...


--
Stan Sieler                                          [log in to unmask]
                                     http://www.allegro.com/sieler.html