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

On Tuesday, August 3, 2010, Oliver Peters <oliver....@web.de> wrote:
> Am Dienstag, den 03.08.2010, 23:24 +0100 schrieb Paul Sanderson:
>
> [...]
>
>> I  the process to be as quiick as
>> possible (although I know it will take minutes). The process at the
>> moment is to drop the indexes, add the new rows and then reindex.
>>
>> Is this the best/fastest  way of achieving this - is there a faster way?
>
> [...]
>
> BEGIN TRANSACTION;
>
> INSERT INTO table(a,b,c) VALUES(1,2,3);
>
> --more INSERTS
>
> COMMIT;
>
>
> Oliver
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

-- 
Paul Sanderson
Sanderson Forensics
+44 (0)1869 325667
www.sandersonforensics.com
http://www.twitter.com/sandersonforens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to