On 6 Jan 2011, at 2:27pm, Olaf Schmidt wrote: > "Alok Singh" <[email protected]> schrieb > im Newsbeitrag > news:[email protected]... > > [Importing from Text-Files] >> ... that's *PERFECT* , much faster than my expectation >> 0.6 min can able to access 10.5k row records. > > If that's not a typo (and you mean 0.6 seconds instead) - > then it is not yet "entirely perfect", I'd say... ;-) > > You wrote, that you expect up to 1Mio-Records - > do you really want to wait for about 1 hour, to have > that available in an SQLite-DBTable?
Alok is writing in a language which doesn't compile very well. And he has another system which splits his data up into smaller chunks (presumably the 10.5 rows) before it gets to the one which uses SQLite. But it might be worth trying larger chunks, since much of the 35 seconds could be overhead and doubling the amount of data might not take much more time. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
