2008-08-13, 04:31 PM
I imported a dish xml tv file that's ~170mb using mc2xm (gbpvr.db3 file is ~100mb)l. It seems to make gbpvr crawl at several points in the setup process, but more importantly, everytime I load gbpvr front end, it will take quite some time before the tvguide completely loads. Time to actual watchable content is about 2 minutes.
It seems like the tvguide is loading all days worth of data for 1 channel and then going to the next... Is it possible to load only today's content and go down and then the next days ?? I've used other EPG and gbpvr seems to have the slowest one out there.
Is there some sqlite profiling that can be done here? I'm thinking some changes to the indices might help. Does anyone know what sql is being run behind the scene so that I could tweak the guide myself ?
Thanks!
I'm running a P4p800 2ghz 1gb ram.
It seems like the tvguide is loading all days worth of data for 1 channel and then going to the next... Is it possible to load only today's content and go down and then the next days ?? I've used other EPG and gbpvr seems to have the slowest one out there.
Is there some sqlite profiling that can be done here? I'm thinking some changes to the indices might help. Does anyone know what sql is being run behind the scene so that I could tweak the guide myself ?
Thanks!
I'm running a P4p800 2ghz 1gb ram.