On 7 Jan 2011, at 1:08am, GS wrote: > Recordsets are common db programming objects, and so I'm a bit awe > struck that you wouldn't know what I mean by the term being as you seem > to be very knowledgeable in SQLite. I'm assuming (rightly or wrongly) > then that you're familiar with db terminology.
I haven't read a book on database theory for 20 years. You're using 'recordset' to indicate a bunch of records ? All the records in a CSV file or a SQL table ? Okay. No I don't think I've heard the term before. > If I used ADO to grab the data from a delimited file into a recordset, > could I then 'dump' that data into a table? My reason for asking is > that I don't use commas nor tabs to delimit data. Thus, if I were to > convert my apps from storing data in text files to using a SQLite > database, I would use ADO to load the data into a recordset. (I'm > considering going with SQLite as apposed to using MDBs) What are ADO and MDB ? MDB is Microsoft DataBase ? That means nothing to me: is it a specific file format or an API or what ? <google> Oh, I see: they're both Microsoft things. ADO is something to do with ActiveX. Sorry, I don't use Windows if I don't have to and have not used either of them. You can certainly convert a database in any format to a SQLite database. Just write some code to read one and write the other. Efficiency doesn't matter, because it only has to be done once, right ? Google finds this, but I don't know how good it is: http://www.tech-archive.net/Archive/Data/microsoft.public.data.ado/2006-11/msg00033.html > Fact is, using text files has its limitations. The file I mentioned in > my reply to Olaf was an exceptionally large one for the data my apps > store. Most files are well under 5,000 records and so I commonly hold > several files in as many arrays at runtime. (Each file would typically > be less than 200KB) I think storing the data in a database would be a > better idea for larger amounts of data. SQL is good for accessing lots of data and searching through it quickly. If you always need to access those 5,000 records in the same order, a text file is fine. If you need to search through it a lot, SQL is probably better. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
