Hello, Thanks. That's rock .... Greate.
Cu Carsten -----Ursprüngliche Nachricht----- Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Im Auftrag von Dan Bishop Gesendet: Samstag, 9. Januar 2010 18:14 An: General Discussion of SQLite Database Betreff: Re: [sqlite] Import a other database. Search for the fastes way 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
