2013-02-01, 02:21 AM
I posted here in Developers as I need some helped from tech minded folk.
I'm trying to find a more efficient way of handling large amounts of EPG data when a user has a lot of TV channels configured for npvr.
At the moment I create 7 individual XML files for nDroid (one for each day) using a query similar to the following...
With my setup of 67 channels, it returns 1060 results for 1 day but if I create a query for a single channel for an entire week similar to...
...I get 260 results which is less than 1/4.
So...a little request for help - if anyone is happy to spend a few minutes playing with SQL queries on their npvr database, I'd appreciate some comparisons between the number of results returned with the two queries above. I'm particularly interested in anyone with a lot of channels (perhaps 120+ and definitely 150-200 or more). Obviously the second query will need adjusting for a valid channel_oid.
Cheers,
Brian
I'm trying to find a more efficient way of handling large amounts of EPG data when a user has a lot of TV channels configured for npvr.
At the moment I create 7 individual XML files for nDroid (one for each day) using a query similar to the following...
Code:
SELECT * FROM EPG_EVENT WHERE end_time > '2013-02-02 00:00:00' AND start_time < '2013-02-02 23:59:59' ORDER BY channel_oid
Code:
SELECT * FROM EPG_EVENT WHERE end_time > '2013-02-02 00:00:00' AND start_time < '2013-02-08 23:59:59' AND channel_oid = 10029 ORDER BY start_time
So...a little request for help - if anyone is happy to spend a few minutes playing with SQL queries on their npvr database, I'd appreciate some comparisons between the number of results returned with the two queries above. I'm particularly interested in anyone with a lot of channels (perhaps 120+ and definitely 150-200 or more). Obviously the second query will need adjusting for a valid channel_oid.
Cheers,
Brian