On 4 Oct 2016, at 6:30pm, Roger Binns <rog...@rogerbinns.com> wrote:
> On 04/10/16 03:11, Werner Kleiner wrote: >> ... after 6000 records. >> >> Is there a limitation with huge inserts? > > While there may be "Lite" in the name, SQLite copes very well with > "huge" stuff. > > That means many many gigabytes in database sizes, many many millions of > rows, up to 2GB per row etc. 6,000 records probably fits in caches, and > isn't remotely close to huge as far as SQLite is concerned. But note also that you can mess yourself up. So if you think you're going to speed things up by setting journal_mode = MEMORY, and you have 8GB of memory free, and you do a transaction which takes up 40GB then you have only yourself to blame. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
