0 Replies Latest reply on Jul 28, 2011 12:02 AM by Dhwani_K_shah

    Which one is better? - filter data using arraylist or firing SQL query?

    Dhwani_K_shah Level 1


             I am Curently working on an AIR application ( flex 4.5 , cairngorm framework ) and having sqlite as database solution. My query is related to speed of fetching data.

      currently what i am doing is selecting all data from tables and then storing it into arraylist.Maintaining that arraylist into modellocator. And then whenever i add a new record or delete or update that table's record , i am updating the arraylist of modellocator. So i am referring to that arraylist everywhere whenever i need to display list of records. Is this corrcect or should i always fire sql query after inserting or deleting or updating a record? which one is better?


      Help is always appriciated,