Carsten Giesen wrote:
> Now my question.
>
> I work on a way to have a cache DB from the Main Server on the PC of my
> client.
> In the case the server is down they can go on working. (Like Outlook and
> Exchange)
>
>
>
> For the first time I have to copy a lot of data from the main server.
>
> In the moment I do it Table by Table, and Row by Row in a for each loop.
>
> An then "INSERT INTO {table} (Field..) values (Item.)"
>
>
> Is the a faster way?
>
Put a "BEGIN TRANSACTION" before your loop and a "COMMIT TRANSACTION"
after it. Otherwise, each INSERT statement is its own transaction,
which is *much* slower.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
