SQLite Forum

Is there a way to optimize this UPDATE command to run faster?
Login
I don't think you need the second two indexes, as the first index can do everything that the others can. Maybe they make lookups a bit faster as they are smaller, but need to be updated for every new insertion slowing that down.