"GS" <[email protected]> schrieb im Newsbeitrag news:[email protected]...
> > 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). > > <FWIW> > I just checked a 21,000 line x 30 column delimited file > and it is 817KB. Hmm, the filesize seems a bit small for 21000 rows x 30 columns. As I see it, each delimited "record-row" would consume at least 30 delimiter-chars - and 30*21000 is already about 615KB. Are these mostly NullValues in your file?... ;-) > What I was hoping to learn here is whether we can dump > an entire recordset into a SQLite table. Is that doable. Check out the SQLite-NWind-DemoApp which comes with my wrapper - among others, it contains a small Form: fInMemoryDBFromADO There's a routine in it, named: CreateTableFromADORs It should do, what you're looking for. BTW, as for "Recordsets and related terms" - these are mostly "MS-inventions", which are not all that common here, since SQLite can be used on a whole lot of different platforms and with all kind of languages. We VB-users are only a small fraction here - please stay for a while, it's a good occasion, to get a decent reality-check, on "what's going on outside of the MS-universe" <g>. "Resultsets" is perhaps a more common term for a "bunch of detached records in a container, which can be passed around by pointer" ... ;-) Olaf _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
