2012-07-31, 20:43
(2012-07-29, 17:47)`Black Wrote: The script is far from optimal and using the ATV2 together with a mysql database could be the problem why it's only working sometimes. As I said a while ago, this needs to be added natively... it would solve all performance problems as well as some other problems, e.g. if you mark episodes as watched manually.
I have a remote mysql database and it works very reliably, but slowly. With the 130 tv shows in my database and roughly 12k episodes, it takes about 4 minutes for the script to run.
I have done everything to tune the db and the server is not being taxed at all. I would agree with `Black that the only remaining potential improvement would be native implementation. To process these in a plugin the full lists have to be pulled and it is not possible to use the advantage of the mysql server to do any of the heavy lifting for you. If it were a native implementation, mysql server could do most of the work for you.