On 4 Aug 2010, at 12:20am, Paul Sanderson wrote:

> Thanks Oliver that is what I am doing at the moment. I was wondering
> whether there might be  a quicker way maybe using temporary tables for
> similar - just exploring ideas

No need.  Any efficient way of doing it boils down to either

BEGIN ... INSERTs ... END

or

DROP INDEXes ... BEGIN ... INSERTs ... END ... CREATE INDEXes

Which of the two is faster depends on quite a complicated set of criteria.  If 
the difference between the two makes a difference to you in real life then I'd 
suggest you try them both and adopt the one which is currently faster.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to