NPVR and transcoding

[mark_lt]

I will give it a try as soon as I can.

[mark_lt]

Hi Sub,

Thanks again for all the support. Things I have done:
1) Set both to false. It all works fast, as expected, but obviously recordings are not renamed.
2) I then set each on to true or false separately. When Check for rename is true, it slows right down after a recording has been transcoded. Setting autoremove to true, and then manually deleting a recording (through windows explorer) has no noticeable change on performance. NPVR auto deletes and carries on as per normal.
3) I replaced the existing DB3 with the empty one, to see if it was a problem with existing records. The same results. It seems to slow right down on checking for renamed records. This is with just one recording in the database.

Let me know if I should try anything else?

[sub]

Whenever either of those are set to true, it actually needs to check the file is actually on disk as it loads the recording list. I've got about 300 recordings, and I dont have any noticable slowdown checking the list, but maybe recordings are on a network drive, or you imported recordings that are in a non-existent or non-reachable directory try? These conditions will definitely be slower. If none of those are true, then maybe you've just got a slower drive than me.

[mark_lt]

I'll keep working on it, and if I figure a work around I will post. Thanks for the help.

[mark_lt]

Just to finish this thread in case someone has the same challenges. I have accepted that my PC that I use is old. I have also accepted that NPVR is beautiful, and now that I have seen it, I can't go back to GBPVR!

If I am going to transcode, I have to set the check for renamed recordings to false, otherwise it is just to slow to work with and will cause a small revolution in my house.

As part of the post processing batch file, I include a reference to sqlite3.exe and a SQL update query which changes all records in the NPVR.db3 database with a TS extension to one with a MP4 extension. I convert everything from TS to MP4 so there is no need for me to do anything more intelligent.

Not very pretty, but it works for me.

Thanks Sub for you help on this. Just to also confirm based on some of your comments, I checked and there were no networked files, and I did a full defrag with Auslogics so the files on the drive are as organised as can be. It must just be a case of an old PC.

[wodger]

Not that I use this feature, but what do you define as old? Haven't switched to NPVR yet

[mark_lt]

PC itself is fine for what I need. AMD 2400+ with a old old but usable GFX5200 graphics card. I think my issue may be with the old 150 GB IDE drive I'm using (long past its sell by date). It is only this one item (renaming transcoded recordings) that is going slow. I'm finding in general NPVR seems to work a bit faster (might just be my imagination).

Looking at your specs, I would be surprised if you had any issues, but since I have only ever use it on the PC I have, I can't comment on a minimum or recommended spec.

I can understand you not wanting to make the jump to NPVR in beta, but I think it would be worth it in the long run.

[mark_lt]

Just as an update, I had a request for the SQL and post processing bat, so have just put them in here:

This is in the line from postprocessing batch file to call SQLlite3 and the sql query saved in a file called update.sql:
"C:\Documents and Settings\All Users\Application Data\NPVR\Scripts\sqlite3.exe" "C:\Documents and Settings\All Users\Application Data\NPVR\npvr.db3" < "C:\Documents and Settings\All Users\Application Data\NPVR\Scripts\update.sql"

Update.sql is pretty much this:
update SCHEDULED_RECORDING set filename= substr(filename,1,length(filename)-3) || '.mp4' where filename LIKE '%.ts';

It just finds all recordings listed as .ts and changes it to point to my transcoded mp4 files.

[Dave72]

Did you ever check that drive with a SMART utility (presuming the drive features SMART).
Could be internal errors slowing the drive down.

[mvallevand]

That said, if you do convert files and delete the original .ts file, it should detect the new file and update the database automatically.

Does NPVR use <AllowedMediaExtensions> for this detection? If a .ts file is deleted and a .wtv file of the same name is there will everything be done automagically?

Martin