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
Support
General Support
Lost EPG / Channels won't tune
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="mm1352000" data-source="post: 805631" data-attributes="member: 82144"><p>Hi feriso</p><p></p><p>When the database gets corrupted it is generally because data is not written to the HDD. That can happen in several ways including:</p><p>- software crash</p><p>- system BSOD</p><p>- loss of power</p><p></p><p>I see quite a few people with corrupt MySQL databases but I've never seen a report of a corrupt SQL Server database. The main point causing the difference in reliability is that we use MyISAM tables (which don't support transactions) for MySQL, whereas SQL Server access always uses transactions. Using MyISAM makes database access faster, but it also makes the database more prone to corruption. If you want bulletproof reliability then you're possibly better to choose SQL Server.</p><p></p><p>mm</p></blockquote><p></p>
[QUOTE="mm1352000, post: 805631, member: 82144"] Hi feriso When the database gets corrupted it is generally because data is not written to the HDD. That can happen in several ways including: - software crash - system BSOD - loss of power I see quite a few people with corrupt MySQL databases but I've never seen a report of a corrupt SQL Server database. The main point causing the difference in reliability is that we use MyISAM tables (which don't support transactions) for MySQL, whereas SQL Server access always uses transactions. Using MyISAM makes database access faster, but it also makes the database more prone to corruption. If you want bulletproof reliability then you're possibly better to choose SQL Server. mm [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
Lost EPG / Channels won't tune
Contact us
RSS
Top
Bottom