On Sat, 9 Jan 2010 14:39:29 +0100, "Carsten Giesen"
<carsten.gie...@3c-solutions.de> wrote:
>Hello,
>
>
>first I want to say hello, I'm the new ;)
Welcome to the club!
>I'm a newby in SQLite but I'm not new in SQL.
>
>My main DB is MSSQL and I see, as we know from Microsoft, there must be a
>lot of differences.
>
>
>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?
If speed is your concern, you probably forgot to wrap a
series of INSERT statements in a transaction
(BEGIN; INSERT; INSERT; INSERT ... COMMIT;)
I usually do 1000 or 10000 inserts per transaction.
The SQLite command line tool has a .import command which can
handle comma separated values, but it is a bit limited in
the csv 'syntax'.
>By the way. Is there some HowTo for SQLite?
>The Docu give me only the syntax.
There is a wiki witha load of information.
http://www.sqlite.org/cvstrac/wiki
Contributions to the wiki are welcome.
>With kind regards
>Carsten
Hope this helps.
--
( Kees Nuyt
)
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
