On 6 Jan 2011, at 8:18pm, GS wrote: > I just checked a 21,000 line x 30 column delimited file and it is > 817KB. I draw the line (for performance and/or convenience working with > the data) at about 50K lines before I'd use ADO to load the entire file > into a recordset, OR criteria-specific recordsets depending on how I > want to work with it. > > What I was hoping to learn here is whether we can dump an entire > recordset into a SQLite table. Is that doable.
Are you worried about how many columns, rows or bytes you can store in SQLite ? The size you mention is nowhere near the capacity limits. You won't have any trouble with that amount of data. If you're worried about something else, please make the question clearer. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
