Reply to thread

Message

<blockquote data-quote="misterd" data-source="post: 220096" data-attributes="member: 19503">Graph building takes here ~1 second. For me this is fast enough, but for sure there are improvements and your idea is really good. My problem is that you need a fallback system when something has changed and than update the db etc.During my tests I found out that it only takes very long to connect pins, if you try to connect to a pin that is already connected to a different pin. Therefor my modifications just checks at first, if the pin is already connected.The TvServer tries different filters, but only while it tries to add a specific one. There is no retry if there an error occurs somewhere later in the graph building process.Perhaps I will think about how such a problem could be solved at weekend.MisterD1. Perhaps the channel switching is also improved here, but I'm not quite sure.2. Since I'm not a developer of MP, I can't commit the patch into SVN.3. You have to connect to the db server with the SQL Server Management Studio. Than select the Database &quot;TvLibrary&quot; and delete there the table by right-clicking on the table and selecting &quot;Delete&quot;.But I highly suggest only to try the patch, if you know what you are doing. The reason is quite simple. If the patch will be included sometime in SVN and you haven't deleted the table properly, you'll get an error when you update to this version. Perhaps I will post some delete scripts at weekend when I find some time.MisterD</blockquote>

[QUOTE="misterd, post: 220096, member: 19503"] Graph building takes here ~1 second. For me this is fast enough, but for sure there are improvements and your idea is really good. My problem is that you need a fallback system when something has changed and than update the db etc. During my tests I found out that it only takes very long to connect pins, if you try to connect to a pin that is already connected to a different pin. Therefor my modifications just checks at first, if the pin is already connected. The TvServer tries different filters, but only while it tries to add a specific one. There is no retry if there an error occurs somewhere later in the graph building process. Perhaps I will think about how such a problem could be solved at weekend. MisterD 1. Perhaps the channel switching is also improved here, but I'm not quite sure. 2. Since I'm not a developer of MP, I can't commit the patch into SVN. 3. You have to connect to the db server with the SQL Server Management Studio. Than select the Database "TvLibrary" and delete there the table by right-clicking on the table and selecting "Delete". But I highly suggest only to try the patch, if you know what you are doing. The reason is quite simple. If the patch will be included sometime in SVN and you haven't deleted the table properly, you'll get an error when you update to this version. Perhaps I will post some delete scripts at weekend when I find some time. MisterD [/QUOTE]

Verification