home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Development
General Development (no feature request here!)
efficient database code
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="jameson_uk" data-source="post: 596988" data-attributes="member: 11220"><p>I want to scan a set of files say 20,000 and store them in a SQLite database. </p><p>Actually doing this is straight forward enough but I am wondering what the most efficient way of doing this is.</p><p>I have a class to model the files which has about 20 attributes.</p><p>Having used ADO with VB a few years ago and reading up on ADO.NET it looks like paramaterized queries are still the way to go. The question though is whether I process the files individually or whether I store the files in some sort of collection and then process the whole lot in one go.</p><p></p><p>Just wondering what the hit on memory usage / speed would be storing this many objects in a collection.</p></blockquote><p></p>
[QUOTE="jameson_uk, post: 596988, member: 11220"] I want to scan a set of files say 20,000 and store them in a SQLite database. Actually doing this is straight forward enough but I am wondering what the most efficient way of doing this is. I have a class to model the files which has about 20 attributes. Having used ADO with VB a few years ago and reading up on ADO.NET it looks like paramaterized queries are still the way to go. The question though is whether I process the files individually or whether I store the files in some sort of collection and then process the whole lot in one go. Just wondering what the hit on memory usage / speed would be storing this many objects in a collection. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
General Development (no feature request here!)
efficient database code
Contact us
RSS
Top
Bottom
