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
