Sharing epg between gbpvr and npvr

[JimmyA]

Sorry, is this any better?

[sub]

How long did you wait for it? There is no sign of any problems in that log.

[JimmyA]

That was just a log where I deleted as soon as my system slowed down. Here is a log where it had been running for just over fifteen minutes.

I see that it is deleting the old guide. But why does it take so long? I have let it run for over 2 hours and had to kill it. Also, while it is deleting, my system is barely responsive.

Thanks for looking...

[JimmyA]

sub,

When deleting old listings, does it match only on the oid column? Just noticed that the indexes on the old gbpvr databae are different from the npvr database. Trying to improve sqlite performance. I did 'vacuum' the database and the deletes appear to be running a little quicker.

[sub]

We've not noticed any problems with this until now, but possibly its not working well with the large number of channels and listings you have.

You could try adding an index on the channel_oid column of the EPG_EVENT table. If it helps, I'll add one in the master database.

[JimmyA]

sub,

I agree that I need to trim down my channel listings. Hadn't realised is was so extensive. If it is still slow, I will add the index that you suggested and see if that helps.

Many thanks for your help.

[JimmyA]

sub,

Where do I disable channels from loading to the database epg in npvr? In the gbpvr config app there is an 'enabled' check box.

If I right click in the main menu from npvr and select 'Channels', nothing comes up. I can select 'Settings' then 'Channels' but don't see an option to disable a channel.

Thanks

[sub]

sub,

Where do I disable channels from loading to the database epg in npvr? In the gbpvr config app there is an 'enabled' check box.

Just go to the Channels screen in the Setting screen, highlight the channels you dont want and hit 'Delete'.

[JimmyA]

sub,

Trimmed my epg to about 275 channels. Now takes 25 minutes to update in npvr. There is already an index on the channel_oid column.

Many thanks for your help.

[sub]

Zip and email me your database, and your xmltv file and I'll take a look how long it takes here, and will improve it. I'll PM you my email address.