nop no i ment up to 50 MB an these are tough to import(i just wanted to mention that because on these records import is slownig down and it is not so fast any more example if i import one set of data that is small and the other that is large the overall time is T1= t1 +t2 but if i mix those data T2 > T1), db is 32 GB in total size
D. Richard Hipp wrote: > > > On Mar 19, 2009, at 9:38 AM, baxy77bax wrote: > >> >> >> :-D >> >> one more question : >> >> if i create primary key on my table and then import the data >> (assuming i >> used transactions) will my import be faster or slower vs the case >> where i >> import the data first and then create key (foreign key ??) and index >> the >> table. >> >> the point is that i need my import to be faster. i have 3890660 rows >> to >> import and row van be up to 50M large, so it's taking a pretty long >> time > > > Do I understand you correctly? 3.8 million rows at 50MB per row comes > to almost 200 TB. > > The maximum size of an SQLite database with a 32KiB page size is 64 > TiB. The maximum size of a file on ext3 is 2 TiB and 16 TiB on ext4. > On NTFS, 2 TiB is the maximum size of an entire volume. > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/is-primary-key-already-indexed---tp22596778p22600912.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
