Reply to thread

Message

<blockquote data-quote="CyberSimian" data-source="post: 1263254" data-attributes="member: 141969"><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" /> <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" /> <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek!&nbsp; &nbsp; :eek:" loading="lazy" data-shortname=":eek:" />At some point in the past, MP1 changed from MySQL 5.2 to MySQL 5.6, which on my system caused a very noticeable slowdown in the EPG grabbing, due entirely to the database updates <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown&nbsp; &nbsp; :(" loading="lazy" data-shortname=":(" />.MySQL 5.6 is roughly a factor of three slower than 5.2. I understand that this was due to a different internal structure to the database in 5.6 compared to 5.2.&nbsp; The benefit of 5.6 is that it is less vulnerable to database corruption due to applications not accessing or updating it correctly (or something like that). So I suppose the price of a more robust database is worse performance. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite3" alt=":(" title="Frown&nbsp; &nbsp; :(" loading="lazy" data-shortname=":(" />-- from CyberSimian in the UK</blockquote>

[QUOTE="CyberSimian, post: 1263254, member: 141969"] :eek: :eek: :eek: At some point in the past, MP1 changed from MySQL 5.2 to MySQL 5.6, which on my system caused a very noticeable slowdown in the EPG grabbing, due entirely to the database updates :(. MySQL 5.6 is roughly a factor of three slower than 5.2. I understand that this was due to a different internal structure to the database in 5.6 compared to 5.2. The benefit of 5.6 is that it is less vulnerable to database corruption due to applications not accessing or updating it correctly (or something like that). So I suppose the price of a more robust database is worse performance. :( -- from CyberSimian in the UK [/QUOTE]

Verification