"Alok Singh" <[email protected]> schrieb im Newsbeitrag news:[email protected]...
> yeah that's correct Simon, its in 0.6 sec to insert > for 10.5K rows with 20 columns (2 files both > having 10.5k rows) That's the timing I would expect, if you'd have used Garrys recommendation (to read in the whole file into a String first, and then split the string into an Array "InMemory", finally followed by an Insert- Transaction, which makes use of this 2D-Array). That's memory-intensive - but "Ok" (and fast) for Testfiles with that RowCount (filesize of your 10.5K-Rows testfiles around 4-6MB I'd guess). Are you sure, that your replies address the person you have in mind ... your previous reply was going to Garry - and your last reply here was going to me, and "both of us" are not Simon (who is a very helpful person on this list, no doubt about that... :-). Olaf _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
