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