home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Development
Improvement Suggestions
Database Vs Shares UI
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Swede" data-source="post: 343465" data-attributes="member: 24638"><p>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?</p><p></p><p>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?</p><p></p><p>Funny thing is that even if the database is clear, and no thumbs exist, the procedure takes as long.</p><p></p><p>If you want to test a little, the databases.dll with the extra log entries is attached.</p><p></p><p>These are the procedures in VideoDatabaseSqlLite.cs:</p><p></p><p>2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetFileId(string strFilenameAndPath)</p><p>2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetFile</p><p>2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi </p><p>2008-12-13 12:29:02.718750 [Debug][MPMain]: cde_GetPath</p><p>2008-12-13 12:29:02.734375 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer </p><p>2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetMovieInfo</p><p>2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact</p><p>2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetFile</p><p>2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi </p><p>2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetPath</p><p>2008-12-13 12:29:02.765625 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer </p><p>2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_HasMovieInfo</p><p>2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact</p><p>2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetFile</p><p>2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi </p><p>2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetPath</p><p>2008-12-13 12:29:02.781250 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer </p><p>2008-12-13 12:29:02.812500 [Debug][MPMain]: cde_GetMovieInfoById</p><p></p><p><span style="color: Red">The above log is from a client with XP, while MP is running (idle) in my Vista server. </span></p><p><span style="color: Red">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</span></p><p>2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetFileId(string strFilenameAndPath)</p><p>2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetFile</p><p>2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi </p><p>2008-12-15 10:18:33.393125 [Debug][MPMain]: cde_GetPath</p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer </p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetMovieInfo</p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact</p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetFile</p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi </p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetPath</p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer </p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_HasMovieInfo</p><p>2008-12-15 10:18:33.408750 [Debug][MPMain]: cde_GetMovie(string strFilenameAndPath, bool bExact</p><p>2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetFile</p><p>2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer\007 Casino Royale cd1.avi </p><p>2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetPath</p><p>2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetDVDLabel : \\tv\c\Filmer </p><p>2008-12-15 10:18:33.424375 [Debug][MPMain]: cde_GetMovieInfoById</p></blockquote><p></p>
[QUOTE="Swede, post: 343465, member: 24638"] 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 [COLOR="Red"]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[/COLOR] 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 [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
Improvement Suggestions
Database Vs Shares UI
Contact us
RSS
Top
Bottom