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?