4 Replies Latest reply: Jun 6, 2013 8:07 AM by Prem Kumar Thangallapally RSS

    comparing "where exists" and "applymap"

    Mehmet Çaldak

      Hello Community,

       

      i've a qvd has 49 M lines and i need to load it into a qwv file but not all lines just the lines filtered by a certain field. when i considered the possible methods to filter the data, i decided to test "where exists" and "applymap" techniques. firstly i tried  "where exists" and it took more than 17 min to load from qvd, then i tried "applymap", it was amazingly faster, it took just  less than 3 min. i can't understand, why such a big difference occur between these two methods ?

       

      best regards.