[confirm] XMLTV forced import freezes TV Server Setup (1 Viewer)

[Herr R aus B]

Hitting the import button in TVXML plugin freezes TV Server Setup completey - at least the GUI. Regarding to TV.log, all schedules from the given tvguide.xml have been imported. TV Server Setup must be teminated with Task Manager as even the taskbar context menu wouldn't show up. See attached logs. and used tvguide.xml.

Regards axel

 

[arion_p]

Please wait at least a couple of minutes after XmlTV seems to be doing nothing. The process is as follows:

1. tvguide.xml is read in memory and program info extracted
2. programs info is queued for insertion to the database
3. while the queue is being filled, program info from the queue are inserted in to the database.
4. the database importer waits for 60 seconds to ensure no other insertions will be queued
5. program states are recalculated

All these steps must be carried out for a successful import. So even though it seems nothing is happening, SetupTV is actually waiting for the 60 sec timeout in order to recalculate program states.

 

[Herr R aus B]

OK - after some 05:30 minutes TV Setup returned - but anywaxy - under 1.0.2 the same procedure took some seconds and everything was fine. Why all this waitng? Sounds like a very asynchronous implementation and watiting for processes going on in the background. Maybe no bug, but at least suboptimal performance Thanks for the quick reply anyways

Regards

Axel

 

[arion_p]

Yes this process is designed to work in the background, and is not suitable for running manually.

Doing a manual import from SetupTV is only meant for test purposes.

Edit: The whole process takes longer for two additional reasons:

1. All inserts are performed in a single transaction, which makes it slower. Previously, existing programs would be removed and then EPG would be populated incrementally. If a scheduled recording happened to be starting at this time the corresponding program entry might be missing, resulting in wrongly named recordings or missed recordings.
2. After all program info has been imported, program states are recalculated. Program states define whether a program is scheduled for recording or notification, if it is currently recording, etc. They are used to speed up TV Guide. Previously this information was calculated each time you entered TV Guide making it very slow. If you have many schedules, recalculating program states can take considerable time (in the order of a few minutes).

 

[Herr R aus B]

Indeed TV Guide got much (!) faster - one of the things I really was amazed with!