Database Vs Shares UI (1 Viewer)

[yevgenb]

I'm not a newbie but still using shares view also.
Same reason - cartoons and children movies stored in the different folders, also there are some movies that doesn't have IMDB info thus "Moving Pictures" or DB view is useless.

BTW - I haven't seen "slow behavior" as mentioned but some other bugs instead...

 

[Swede]

I inserted som more log entries in VideoDatabaseSqlLite.cs and found that the procedures in there takes one tenth of a second for each file I have in that directory. 300 movies gives 30 seconds wait, for each time the list is about to show. Even if you stop a movie it takes that time for the list to come back. Nothing seems to be cached. Why is nothing cached?

The time per movie is probably different for different cpu's, but anyway, the procedure needs to be different. Now ALL info for every file in the directory is gathered EVERY time the list shows. I think thats unnessesery. To first list the files and THEN add the info, while they are viewed would probably be faster. Or maybe the virtual directory is ment to be used?

Funny thing is that even if the database is clear, and no thumbs exist, the procedure takes as long.

If you want to test a little, the databases.dll with the extra log entries is attached.

These are the procedures in VideoDatabaseSqlLite.cs:

2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetFileId(string strFilenameAndPath)
2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetFile
2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi
2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetPath
2008-12-13 12:29:02.734375 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer
2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetMovieInfo
2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact
2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetFile
2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi
2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetPath
2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer
2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_HasMovieInfo
2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact
2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetFile
2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi
2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetPath
2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer
2008-12-13 12:29:02.812500 [Debug][MPMain]: cde_GetMovieInfoById

The above log is from a client with XP, while MP is running (idle) in my Vista server.
Same sequence below, but now MP is closed in the server. ??? As you can see, it only take 1/3 of the time it took with MP on in the server. Now 300 movies take 10 seconds. Somehow, a running MP in the server slows the client down
2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetFileId(string strFilenameAndPath)
2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetFile
2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi
2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetPath
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetMovieInfo
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetFile
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetPath
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_HasMovieInfo
2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact
2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetFile
2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi
2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetPath
2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer
2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetMovieInfoById

 

[Swede]

MUCH faster in MP 1.0 final

 

[tourettes]

MUCH faster in MP 1.0 final

No changes were done on that are lately, maybe it was something that clean install did help?

 

[Swede]

Naa, I was too quick... It's good if MP is NOT on in my server PC, but it's slow (20 sec extra delay) if MP is ON in my server PC.

 

[TommySharp]

"My Videos" is very slow for me if I use shares view on a single seat installation where the server and client are on the same machine.

It'd be great if someone could look at this as it takes about 20 seconds to just open up on of the folders under "My Videos" if it is on a network share....

I like to keep my videos categorized into different folders hence the use of share view.

 

[Swede]

I REALLY wish someone would This problem hasn't been there all the time, you know. I think it came around a year ago.

I have an interesting notation on this:
I think the real problem is with the clients, where it takes about 30 sec, IF MP is running in the server PC, but look here:
IF shares view is selected AND one of the folders is selected as a start folder AND Show last active module when starting is selected THEN, WHEN I start MP it only takes 4 sec to show the selected folder. IF I now leave the folder and go back in, it takes 30 sec.

Log:
First time folder is shown, at MP start:
2009-02-04 18:36:48.725464 [Info.][MPMain]: opening video database
2009-02-04 18:36:49.538032 [Info.][MPMain]: video database opened
2009-02-04 18:36:52.757049 [Debug][MPMain]: GUIVideoFiles: SelectCurrentItem - nothing to do for item -1

Second time:
2009-02-04 18:37:06.695709 [Debug][MPMain]: TextureManager: CleanupThumbs()
2009-02-04 18:37:38.682745 [Debug][MPMain]: GUIVideoFiles: SelectCurrentItem - nothing to do for item -1

Third time:
2009-02-04 18:37:46.417764 [Debug][MPMain]: TextureManager: CleanupThumbs()
2009-02-04 18:38:17.967263 [Debug][MPMain]: GUIVideoFiles: SelectCurrentItem - nothing to do for item -1

Whole log attached

IF someone could find what differs between the first load and the second THEN maybe this extremely annoying problem can be solved.

More on this:
https://forum.team-mediaportal.com/general-support-51/re-slow-browsing-shares-47953/