0037324: slow login having many preferences

  insert into ad_preference
    (ad_preference_id,  ad_client_id,      ad_org_id,
     createdby,         updatedby,         attribute,
     value,              ispropertylist)
    select get_uuid(),  '0',     '0',
           '0',         '0',     'visible-all-'||s, 
           'v:'||s,     'N'
      from generate_series(1,8000) s;

insert into ad_preference
            (ad_preference_id,  ad_client_id,      ad_org_id,         
             createdby,          updatedby,         property,         
             value,              ispropertylist,
             visibleat_org_id)
       slect get_uuid(), 
            '39363B0921BB4293B48383844325E84C', -- Client: The White Valley Group
            '67839EEFA49E44AC969BD60093FCC899', -- Org: The White Valley Group
            '0', '0',  value,
            'v:'||s, 'Y',
            '3B187EC130A549A7A9388F8060EF156D' -- visible at org: Central Mountains Store
       from ad_ref_list, generate_series(1,500) s
      where ad_module_id ='FF808181326CC34901326D53DBCF0018' 
        and ad_reference_id ='A26BA480E2014707B47257024C3CBFF7' -- all POS preferences