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 2
General
Client/Server config best practices
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="MJGraf" data-source="post: 1129560" data-attributes="member: 17886"><p>Hi JSchuricht,</p><p>first of all: thanks for using MP2!</p><p>As to the performance problem on searching: What happens technically is that the MP2-Client via UPnP sends a search query to the MP2-Server. The search query is in the MP2-Server translated into a SQL query, which is then sent to the SQLite database.</p><p>My assumption is that SQLite executes this query in a single thread - which is why the query only utilizes one of your server cores. From the SQLite mailing list I know that there has been an improvement for SQLite to use multi-threading for queries lately. I still need to update SQLite so that we can make use of it.</p><p>Until then: Is there a file called SQLDebug.log in your MP2-Server's log directory? If so, could you please restart MP2-Server (so that the mentioned log is cleared), then use MP2-Client do perform some searches that take too long and then post the SQLDebug.log here?</p><p>If the log file is not there, please let me know. In that case I'll give you a debug build of a dll-file that should produce this log file.</p><p>Thanks!</p><p>Michael</p></blockquote><p></p>
[QUOTE="MJGraf, post: 1129560, member: 17886"] Hi JSchuricht, first of all: thanks for using MP2! As to the performance problem on searching: What happens technically is that the MP2-Client via UPnP sends a search query to the MP2-Server. The search query is in the MP2-Server translated into a SQL query, which is then sent to the SQLite database. My assumption is that SQLite executes this query in a single thread - which is why the query only utilizes one of your server cores. From the SQLite mailing list I know that there has been an improvement for SQLite to use multi-threading for queries lately. I still need to update SQLite so that we can make use of it. Until then: Is there a file called SQLDebug.log in your MP2-Server's log directory? If so, could you please restart MP2-Server (so that the mentioned log is cleared), then use MP2-Client do perform some searches that take too long and then post the SQLDebug.log here? If the log file is not there, please let me know. In that case I'll give you a debug build of a dll-file that should produce this log file. Thanks! Michael [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
General
Client/Server config best practices
Contact us
RSS
Top
Bottom