Recordings Menu Responsiveness

[sub]

Yep, this was on a wireless client - I will try wired later today. The server takes a couple of seconds to do the same.
The database is 12MB. Does the client load the whole file each time or just transfer query and result. The server takes 3 or 4 seconds to delete a recording not that that's a problem but might help.

SQLite isn't a network database server, it just works on reading files, so the client does the query itself by reading the file. How much it has to read depends on how efficient the indexes are etc.

[fluffykeith]

Ah I see, so yes the network needs to be quick. I assumed it was through a tcp socket to the server that did the database access.

I have now connected wired to my LAN and the delay is about 2-3s which is ok - In fact I'm really pleased with my new client running on a little gigabyte brix pc.

My database is old will it get clogged up with old stuff, unconnected indexes or the like?

btw. we like the new look - not sure when it changed as I hadn't updated for a long time.

great job, thanks.

[sub]

Ah I see, so yes the network needs to be quick. I assumed it was through a tcp socket to the server that did the database access.

I have now connected wired to my LAN and the delay is about 2-3s which is ok - In fact I'm really pleased with my new client running on a little gigabyte brix pc.

My database is old will it get clogged up with old stuff, unconnected indexes or the like?

If you can supply your npvr.db3, I can check a few things, and see if I can improve it. Its possible I could improve things with additional indexes etc.

btw. we like the new look - not sure when it changed as I hadn't updated for a long time.

Great - glad you like it. It was just changed in this release.

[fluffykeith]

its 3.58MB so exceeds the upload size for zips.

Just out of interest I have some recordings that no longer play - I'm not sure if the recording location has change or the file corrupt - I'll investigate a bit further but there may be something iffy going on.

[sub]

its 3.58MB so exceeds the upload size for zips.

You'd need to put it somewhere like dropbox / one drive / google drive, and just give me the URL.

[fluffykeith]

here's a url to the file: https://www.dropbox.com/s/cg4ngp4zev2pb6...zip?oref=e

Thanks for taking a look.