Ignacio Renuncio <[EMAIL PROTECTED]> wrote: > I was thinking about the possibility of importing moderately large amounts > of data into MMBase, several thousands of records. > > Is the XML importer the option to use? The recommended one?
I have virtually no experience with XML importer. I think it was created for this purpose yes, but also for matching it with existing data, to avoid duplication. > Has anybody tried to import directly through SQL? Is it possible? What > pros/cons does it have? The pros are probably that it can be implemented very efficiently, the cons are that it would be rather specific for your situation and must be done from scratch which is a a bit tricky because you have to insert excactly as MMBase does (also update numberTable and so on), and you have to afterwards invalidate the caches manually, which is a pro as well, because when using the MMBase API you might pollute the cache which a lot of nodes from the import. I wouldn't opt for it. Michiel -- Michiel Meeuwissen Mediacentrum 140 H'sum +31 (0)35 6772979 nl_NL eo_XX en_US mihxil' [] ()
