D. Richard Hipp Mon, 17 Jan 2005 14:29:17 -0800
item1 is not indexed so the UPDATE has to do a full table scan. Add an index on item1 and it will go much faster.