Move record from one table to another
I have a table of events, which are a kind of 'to do' item. I'm finding that acessing the table via ipad or iphone apps is slow due to the large numbers of completed events in this table. On the mac there is no slowdown, but the ipad (2 and 3) it can be glacial.
So rather than have a field for completed events I thought I'd move the completed events to a separate archive table. The completed events are never needed for day to day queries.
What's the best way to move a record from one table to another?