A lack of a proper index was the cause of his really slow query, which is what a rate of 10 updates per second indeed points to.

Even when the OP is happy now, with an index, method 2 should be faster still. And the difference should be more visible, since less time is spent inside the DB.