SQLite Performance problems?

[cheval]

Here is the latest logs from the reproduction this morning with encoder pass through enabled.

[cheval]

Some things that look strange in the logs:
GBPVR.exe.log:
5/23/2006 8:12:15 AM.390 VERBOSE [1] Switching to channel: 9 (75 TNTHD)
5/23/2006 8:12:28 AM.078 VERBOSE [1] Switching to channel: 10 (97 96 95 94 HDTVSE)
5/23/2006 8:12:35 AM.000 VERBOSE [1] RenewLease: 3
5/23/2006 8:12:37 AM.125 VERBOSE [1] Switching to channel: 11 (202 CNN)
5/23/2006 8:12:50 AM.234 VERBOSE [1] Switching to channel: 12 (203 COURT)

This doesn't show anything interesting except the error:
5/23/2006 8:11:58 AM.906 VERBOSE [6] RecordingFactory.LoadNext24HourEvents()
5/23/2006 8:11:58 AM.906 VERBOSE [6] forcing refresh of next 24 hour events for capture source:3
5/23/2006 8:11:58 AM.906 ERROR [6] Unexpected error loading record schedule for next 24hours: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
5/23/2006 8:11:58 AM.906 VERBOSE [6] Starting LiveTV for captureSource: 3 channel oid: 8 filename:
5/23/2006 8:12:35 AM.015 VERBOSE [9] RenewLease 3
5/23/2006 8:12:35 AM.015 VERBOSE [9] RecordingFactory.LoadNext24HourEvents()
5/23/2006 8:12:35 AM.015 VERBOSE [9] RenewLease finished (accepted - preview mode)
5/23/2006 8:13:01 AM.578 VERBOSE [9] StopPreviewLiveTV()

I am using the the .exe channel changer to switch the channels on the STB. Perhaps there is something different with that ineraction?

[sub]

I'm fairly sure this is related to an error in the data migration to SQLite. Can you send your gbpvr.db3 file over to me at support@devnz.com so I can take a look at your database?

[cheval]

I just sent you the database for the latest reproduction this morning.

The interesting point in the gbpvr.exe.log is probably:
5/25/2006 7:24:01 AM.156 VERBOSE [1] Received event code: 14
5/25/2006 7:24:06 AM.656 VERBOSE [1] Switching to channel: 79 (202 CNN)
5/25/2006 7:24:24 AM.984 VERBOSE [1] RenewLease: 3
5/25/2006 7:24:26 AM.843 VERBOSE [1] Switching to channel: 82 (203 COURT)
5/25/2006 7:24:37 AM.109 VERBOSE [1] Switching to channel: 80 (204 CNNH)
5/25/2006 7:24:47 AM.062 VERBOSE [1] Switching to channel: 96 (206 ESPN)
5/25/2006 7:24:55 AM.609 VERBOSE [1] RenewLease: 3
5/25/2006 7:24:58 AM.515 VERBOSE [1] Stopping recording oid:3

Thanks for the help.

[cheval]

Could it be that I'm picking up the wrong decoder when using the sqlite database versus the access database. Doesn't seem possible, however the problem seem simular to what I've experienced in the past when playing with the different decoders. If I choose something other than the Intervideo decoder then I get either poor playback (lines throughout the video, etc.) or the channel changing is unresponsive (sounds like this problem).

Just a thought .

[Spawn]

Hi,

I just tried out the sqlite database and exactly the same happened to me. So I went back to access.

My specs are

Centrino 2Ghz
1Gb ram
Mobile Fire GL
GBPVR 97.9
WINTV USB2 PVR2

So if someone (sub?) wants to see another logfile or database, just ask.

Spawn

[86atc250r]

I've made a few interesting observations.... For reference my system is a 3.06ghz setup with two tuners (PVR500), winXP pro, VMR9, and nVidia purevideo decoders.

Eariler today I had three days of EPG data in the database & was doing some performance tuning/experimenting. Changing channels was very quick with only a momentary studder during the change & very quick OSD display.

This was an improvement over what I've had in the past with Access or SQL lite with 14 days EPG.

Later this afternoon I updated my EPG with 14 days - immediately my channel changing slowed to a crawl with heavy studdering between channel changes, and after the channel changes it would take a few moments to actually display the OSD.

Further, any time now with 14 days of EPG that I pull an OSD, the system studders and slows down until the OSD is displayed.

Next test was to select the minimal OSD option - channel changes are now instant with zero studdering.

Another point of note - when replaying recorded video, using the OSD creates no studdering.

Another test I tried was to change the VMR setting - the system would still studder while retrieving the data for the OSD regardless of the VMR setting. It really seems by all indications to be a delay of some sort due to retrieving the data to put in the OSD

[sub]

Can you zip and email your gbpvr.db3 database to me at support@devnz.com?

[Jim_]

Hi,
Spawn

Spawn, when I noticed your name I just had to ask.
The DVCII / SVCD Spawn from years ago?

(J) im_
Former DVCII / DCS200 user.

[86atc250r]

Sub, are you talking to me?