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
Improvement Suggestions
SQLite instead of MS SQL
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="scoop" data-source="post: 138675" data-attributes="member: 10498"><p>Hi,</p><p></p><p>In my setup SQL server takes about 24MB of memory (so would a well-configured MySQL database, by the way). I wouldn't call that resource-hungry now that 512MB or even more is pretty much standard.</p><p></p><p>Personally I wouldn't even mind it taking more memory as it will more likely avoid high cost disk I/O and keep the system responding well.</p><p></p><p>Another bad thing (IMHO even worse than the "single writer causes no readers" issue) is that all datatypes are implicitly converted to strings. You can even store a character string in a number field if you'd like to...</p><p></p><p>File databases in the end just don't scale well when being accessed from multiple sources. Not to mention remote connectivity to a database.</p><p></p><p>Kind regards,</p><p>Michel</p></blockquote><p></p>
[QUOTE="scoop, post: 138675, member: 10498"] Hi, In my setup SQL server takes about 24MB of memory (so would a well-configured MySQL database, by the way). I wouldn't call that resource-hungry now that 512MB or even more is pretty much standard. Personally I wouldn't even mind it taking more memory as it will more likely avoid high cost disk I/O and keep the system responding well. Another bad thing (IMHO even worse than the "single writer causes no readers" issue) is that all datatypes are implicitly converted to strings. You can even store a character string in a number field if you'd like to... File databases in the end just don't scale well when being accessed from multiple sources. Not to mention remote connectivity to a database. Kind regards, Michel [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
Improvement Suggestions
SQLite instead of MS SQL
Contact us
RSS
Top
Bottom
