Reply to thread

Message

<blockquote data-quote="Maschine" data-source="post: 30792" data-attributes="member: 10316">Hi!This surely depends on the size of your TV database. I have very detailed data here on my HTPC which is for the next 14 days with ~35 channels. At the moment the algorithms dealing with the data are not very optimised. For example right now the hover data (when you go with your mouse pointer over a show) is loaded for all (!) shows in the guide view.If we changed this to load it just when hovering over the one show you want to see it for it will decrease the database activity a lot. Same is for checking if a show is part of a series recording. There is also a lot of scanning in the database done.Next thing is that using SQLite is slower than using a &quot;real&quot; MySQL-Server for example. This also explains the disc activity as SQLite is only a file on your hdd...The only thing I can say at the moment is that you need to live with this. Sorry. We're all in all still in an early status of our projects and sometimes a quick'n dirty implementation is done to get it working, optimisation will be done later...Maschine</blockquote>

[QUOTE="Maschine, post: 30792, member: 10316"] Hi! This surely depends on the size of your TV database. I have very detailed data here on my HTPC which is for the next 14 days with ~35 channels. At the moment the algorithms dealing with the data are not very optimised. For example right now the hover data (when you go with your mouse pointer over a show) is loaded for all (!) shows in the guide view. If we changed this to load it just when hovering over the one show you want to see it for it will decrease the database activity a lot. Same is for checking if a show is part of a series recording. There is also a lot of scanning in the database done. Next thing is that using SQLite is slower than using a "real" MySQL-Server for example. This also explains the disc activity as SQLite is only a file on your hdd... The only thing I can say at the moment is that you need to live with this. Sorry. We're all in all still in an early status of our projects and sometimes a quick'n dirty implementation is done to get it working, optimisation will be done later... Maschine [/QUOTE]

Verification