Hello BM Whats the best way to import a large number of records ? BM 120K+ currently stored as an XML file.
If your XML data is data-centric, then it should fit into one or more tables quite easily. If it can fit into one table, then you could use XSLT to convert the XML to CSV and .import that into the table you've created. If you need several tables, or because your number of records is large, you could use a SAX implementation (e.g. in Python or PHP) and parse the XML, and bind the values you get from it to placeholders in prepared statements. If the XML is more document-centric, then "adjacency model" and "nested set" were suggested recently as things to investigate for turning a tree structure into something tabular. There are probably lots of other ways to do it, depending on what languages you want to employ. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
