Reply to thread

Message

<blockquote data-quote="bpell" data-source="post: 644788" data-attributes="member: 106216"><p>This is a little late but maybe it will help with posterity.&nbsp; A lot of this depends on memory and machine speed.&nbsp; It's going to be more efficient to read the information in and insert it (or update) the database in that loop with the parameterized query and skip the collection of objects.&nbsp; If you fill a collection or generic list you'll have to iterate through the files, then iterate through that collection to update the DB (all the while, the entire collection is in memory).&nbsp; If you have plenty of memory and a fast machine, not an issue.&nbsp; I'm running MP on a 1.2Ghz with 512mb of RAM. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />&nbsp; It works well, but I prefer using the least footprint.&nbsp; I have a catalog of over 43,000 files and when I've stored the metadata in an Access database I've skipped the object collection and written the data straight to the table.</p></blockquote><p></p>

[QUOTE="bpell, post: 644788, member: 106216"] This is a little late but maybe it will help with posterity. A lot of this depends on memory and machine speed. It's going to be more efficient to read the information in and insert it (or update) the database in that loop with the parameterized query and skip the collection of objects. If you fill a collection or generic list you'll have to iterate through the files, then iterate through that collection to update the DB (all the while, the entire collection is in memory). If you have plenty of memory and a fast machine, not an issue. I'm running MP on a 1.2Ghz with 512mb of RAM. :) It works well, but I prefer using the least footprint. I have a catalog of over 43,000 files and when I've stored the metadata in an Access database I've skipped the object collection and written the data straight to the table. [/QUOTE]

Verification