Channel order after recreating database

[marc]

Hi,
I had been having a problem where it was taking at least 3 seconds to move between the various recordings menus (eg. what's new, pending, recurring) and concluded that the database was possibly corrupt. So I exported the recordings, and recurring recordings and channels from setup then deleted the database, restarted the program to create a new database and imported the exported the recordings, and recurring recordings and channels using setup. This has fixed the original problem but now I have lost the grouping of channels (same channel on DVB-T and sat sources) the EPG sources for them and messed up the order. Have I missed a step or is there an easy way recovering this info from the original database (copy I kept) as I know sorting all of that out in a sensible order takes forever.

Thanks for any ideas help.

[marc]

Managed to sort this myself by repairing the original database file after finding an old post referring to vacuuming the database. I found a copy of sqlite3.exe and placed in the directory with the database then issued the command sqlite3.exe C:\Users\Public\NPVR\npvr.db3 VACUUM; from a CMD window, which has fixed the database!

Original post for reference was here (http://forums.nextpvr.com/showthread.php...r+database)

[sub]

Odd that this would make any difference, since the recording service does a vacuum of the database each time it's started.