Reply to thread

Message

<blockquote data-quote="Lehmden" data-source="post: 1166436" data-attributes="member: 109222">Hi.Probably you can (but dunno how long this two year old and unmaintained plugin will be working...)This I can not understand. MySQL is slow as hell compared to SQLite (a db query take at least 5 times as long in MySQL as it does in SQLite), eats up much more resources and is much more unstable than SQLite. We have done lots of testing before we set our &quot;primary&quot; Database Engine and SQLite was the absolut best with a giant gap. I'm using MP2 for more than a year now in daily usage and not a single issue I had&nbsp; was related to the database engine. In the MP1 days I permanently had issues with MySQL, Lots of Database corruptions and most of the time a not started TV server due to way to long starting time of the MySQL server...One of tthe most important improvements regarding stability of the TVE was the change of the db engine...We are using SQLite in &quot;Write-Ahead Logging&quot; mode so write access to the db file is limited to a minimum. For this a corruption due to system failures is near to impossible. If the system drive crashes completely then the db is lost too. But this is the same for MySQL In all other circumstances the DB did not get corrupted.</blockquote>

[QUOTE="Lehmden, post: 1166436, member: 109222"] Hi. Probably you can (but dunno how long this two year old and unmaintained plugin will be working...) This I can not understand. MySQL is slow as hell compared to SQLite (a db query take at least 5 times as long in MySQL as it does in SQLite), eats up much more resources and is much more unstable than SQLite. We have done lots of testing before we set our "primary" Database Engine and SQLite was the absolut best with a giant gap. I'm using MP2 for more than a year now in daily usage and not a single issue I had was related to the database engine. In the MP1 days I permanently had issues with MySQL, Lots of Database corruptions and most of the time a not started TV server due to way to long starting time of the MySQL server...One of tthe most important improvements regarding stability of the TVE was the change of the db engine... We are using SQLite in "Write-Ahead Logging" mode so write access to the db file is limited to a minimum. For this a corruption due to system failures is near to impossible. If the system drive crashes completely then the db is lost too. But this is the same for MySQL In all other circumstances the DB did not get corrupted. [/QUOTE]

Verification