Slow SQLite update with a simple set expression?

I run a

update mytable set b=a/1000;

and it takes hours on a 20 Mio. row/6GB database.

Is there any tweak I can do it make it faster?