Very slow TV Database?

hoppy · 2006-07-05, 18:14

Area: Media Portal Program
MediaPortal Version: 0.2.0.0 (2006-07-03)
MediaPortal Skin: BlueTwo
Windows Version: Windows XP (SP2)
.NET CLR Version: 2.0.50727
DirectX Version: 4.09.00.0904 (9.0c)
Audio Codec: NVidia Pure Video
Video Codec: NVidia Pure Video
CPU Type: AMD Athlon 64 X2 Dual Core 4400+
Memory: 1 GB
Motherboard: FT20V10 (Shuttle Inc)
TV Card Model: FloppyDTV DVB-S
TV Card Type: DVB
TV Card Driver: 4.2.0
Video Card Model: Radeon X800 Series (256 MB)
Video Card Driver: 8.252.0.0
Video Card Resolution: 1360x768
Video Render Type: VMR9
Audio Card Model: Realtek High Definition Audio
Audio Card Driver: 5.10.0.5116
Synopsis::

Its a gripe rather than a problem, but when you select a programme in the EPG it takes a very long time to bring up the next screen, more than a minute sometimes. While this is happening any playing video freezes (audio continues mind) and the GUI is not responsive.

I'm in the UK with the SKY sattellite package and I know certain programmes can be repeated a lot (mainly on UKTV), I've had 30 pages of upcoming programmes before, but should it really take this long? Is there any kind of optimisation I can carry out on the database once the xmltv import has taken place?

The main problem is that if you select any of the upcomming programmes to record it then takes a very long time before the GUI becomes responsive again.

Nightmare77 · 2006-07-06, 03:31

that sounds very odd, a computer like yours you should not really have any hiccups, perhaps a minor stutter if it was importing the tv guide at the same time, but i can't see why your computer should have any ideas with speed in MP at all.
Perhaps i dont' experience this because in australia we only have like a max of like 7 channels or so free to air. Anyone else in the UK having issues like this?

hoppy · 2006-07-06, 13:34

I tried to reduce the amount of guide data by reducing the "Days to keep in guide" down to 4, but this option seems to be ignored? I cleaned out the guide and ran the grabber and I've still got around 2 weeks of data in the guide.

hoppy · 2006-07-06, 13:55

I deleted most of my channels, down to about 15 or so and edited the xml tv config to remove the deleted channels. I also checked the epgMapping table and the deleted channels had been removed. I re-impoted the guide data and it still takes a very long time to bring up some programmes.

Stargate SG-1 for example has 23 pages of upcomming episodes, and this takes around 20 secounds to appear (when clicked on from the epg). If you click on one of the upcomming episodes you can see it re-building the list with a new programme being added every half a second or so.

Anyone got anymore suggestions?

igalan · 2006-07-07, 16:32

Maybe the TV database is damaged. You can try creating a new one (if you're running 0.2 release).

1.- Back it up, it's called TVDatabaseV21.db3 and it's located in the database folder (save a copy of this file elsewhere),
2.- Open the set up of media portal go to the TV section and where the channel list is located click "Backup" to create a backup and select a folder to store it,
3.- Click accept to close the set up,
4.- Delete the TV database,
5.- Load the set up againg, go to TV, click restore and select the location where you saved the backup,
6.- Click accept to close the set up,

hoppy · 2006-07-10, 18:08

igalan, thanks for the suggestion. I've have already tried that, but I did try it again just in case. I still have the same issue. I think it may just be the number of channels I have set up (around 65), I don't watch most of them so I should probably just delete them

igalan · 2006-07-10, 20:29

If after deleting several channels everything works as expected, maybe one of the devs sould take a detailed look at this problem. You can post the issue in http://www.testteam-mediaportal.com/Joomla/ along with logs and possibly the database. However since the dev is transitioning to a new TV plugin, I don't know how the issue would be treated.

2006-07-05, 18:14	#1 (permalink)
hoppy Portal Member Join Date: Mar 2006 Location: Cambridge, UK Posts: 79 Thanks: 2 Thanked 0 Times in 0 Posts	Very slow TV Database? Area: Media Portal Program MediaPortal Version: 0.2.0.0 (2006-07-03) MediaPortal Skin: BlueTwo Windows Version: Windows XP (SP2) .NET CLR Version: 2.0.50727 DirectX Version: 4.09.00.0904 (9.0c) Audio Codec: NVidia Pure Video Video Codec: NVidia Pure Video CPU Type: AMD Athlon 64 X2 Dual Core 4400+ Memory: 1 GB Motherboard: FT20V10 (Shuttle Inc) TV Card Model: FloppyDTV DVB-S TV Card Type: DVB TV Card Driver: 4.2.0 Video Card Model: Radeon X800 Series (256 MB) Video Card Driver: 8.252.0.0 Video Card Resolution: 1360x768 Video Render Type: VMR9 Audio Card Model: Realtek High Definition Audio Audio Card Driver: 5.10.0.5116 Synopsis:: Its a gripe rather than a problem, but when you select a programme in the EPG it takes a very long time to bring up the next screen, more than a minute sometimes. While this is happening any playing video freezes (audio continues mind) and the GUI is not responsive. I'm in the UK with the SKY sattellite package and I know certain programmes can be repeated a lot (mainly on UKTV), I've had 30 pages of upcoming programmes before, but should it really take this long? Is there any kind of optimisation I can carry out on the database once the xmltv import has taken place? The main problem is that if you select any of the upcomming programmes to record it then takes a very long time before the GUI becomes responsive again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
(original thread) US/Canadian/Mexico EPG Zap2it Plugin Released	bradsjm	zap2it (discontinued)	513	2007-02-21 15:07
Help with TVServer and client	rick78	Get Support	8	2006-12-12 19:48
0.2.1 and latest svn MyPictures thumbnails broken	gloomyandy	Codecs, External Players	1	2006-10-24 11:01
The Setup wizard crash when reaching the autotune step	Wbunaarf	The old Bugreport Forum	19	2006-07-20 02:55
Fusion HDTV5 Gold and external inputs	nst6563	General Support	7	2006-05-27 20:05

2006-07-06, 03:31	#2 (permalink)
Nightmare77 Portal Member Join Date: Jul 2005 Location: Canberra Age: 29 Posts: 520 Thanks: 2 Thanked 1 Time in 1 Post Country: My System	that sounds very odd, a computer like yours you should not really have any hiccups, perhaps a minor stutter if it was importing the tv guide at the same time, but i can't see why your computer should have any ideas with speed in MP at all. Perhaps i dont' experience this because in australia we only have like a max of like 7 channels or so free to air. Anyone else in the UK having issues like this?

2006-07-06, 13:34	#3 (permalink)
hoppy Portal Member Join Date: Mar 2006 Location: Cambridge, UK Posts: 79 Thanks: 2 Thanked 0 Times in 0 Posts	I tried to reduce the amount of guide data by reducing the "Days to keep in guide" down to 4, but this option seems to be ignored? I cleaned out the guide and ran the grabber and I've still got around 2 weeks of data in the guide.

2006-07-06, 13:55	#4 (permalink)
hoppy Portal Member Join Date: Mar 2006 Location: Cambridge, UK Posts: 79 Thanks: 2 Thanked 0 Times in 0 Posts	I deleted most of my channels, down to about 15 or so and edited the xml tv config to remove the deleted channels. I also checked the epgMapping table and the deleted channels had been removed. I re-impoted the guide data and it still takes a very long time to bring up some programmes. Stargate SG-1 for example has 23 pages of upcomming episodes, and this takes around 20 secounds to appear (when clicked on from the epg). If you click on one of the upcomming episodes you can see it re-building the list with a new programme being added every half a second or so. Anyone got anymore suggestions?

2006-07-07, 16:32	#5 (permalink)
igalan Portal Developer Join Date: Jun 2005 Location: Barcelona Age: 36 Posts: 334 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	Maybe the TV database is damaged. You can try creating a new one (if you're running 0.2 release). 1.- Back it up, it's called TVDatabaseV21.db3 and it's located in the database folder (save a copy of this file elsewhere), 2.- Open the set up of media portal go to the TV section and where the channel list is located click "Backup" to create a backup and select a folder to store it, 3.- Click accept to close the set up, 4.- Delete the TV database, 5.- Load the set up againg, go to TV, click restore and select the location where you saved the backup, 6.- Click accept to close the set up,

2006-07-10, 18:08	#6 (permalink)
hoppy Portal Member Join Date: Mar 2006 Location: Cambridge, UK Posts: 79 Thanks: 2 Thanked 0 Times in 0 Posts	igalan, thanks for the suggestion. I've have already tried that, but I did try it again just in case. I still have the same issue. I think it may just be the number of channels I have set up (around 65), I don't watch most of them so I should probably just delete them

2006-07-10, 20:29	#7 (permalink)
igalan Portal Developer Join Date: Jun 2005 Location: Barcelona Age: 36 Posts: 334 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	If after deleting several channels everything works as expected, maybe one of the devs sould take a detailed look at this problem. You can post the issue in http://www.testteam-mediaportal.com/Joomla/ along with logs and possibly the database. However since the dev is transitioning to a new TV plugin, I don't know how the issue would be treated.