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
Submit: code patches (MediaPortal/TV-Server/etc.)
optimize listview controls filling in TVSetup - Channel list for groups
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="Vasilich" data-source="post: 764957" data-attributes="member: 97516"><p>i was disappointed from possibilities of gentle.net - no SQL in SQL, no suffixes for operators (like SELECT <strong>DISTINCT</strong>), and no support, as further development of gentle is abandoned.</p><p></p><p>Still, i found the possibility to write pure SQL queries when using Gentle. So this is my attempt to fix the filling of listviews for channels using dictionaries and pure SQL queries as optimal as possible. I have done it only for tv channel group list, but now it takes 2.5 seconds (instead of 80 seconds originally) for 4600 channels. I think this is an acceptable time i can live with <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /></p><p></p><p>mm and gibman (and maybe other MP devs?), please check the patch and tell your meanings before i apply it on all other places working with channel lists.</p></blockquote><p></p>
[QUOTE="Vasilich, post: 764957, member: 97516"] i was disappointed from possibilities of gentle.net - no SQL in SQL, no suffixes for operators (like SELECT [B]DISTINCT[/B]), and no support, as further development of gentle is abandoned. Still, i found the possibility to write pure SQL queries when using Gentle. So this is my attempt to fix the filling of listviews for channels using dictionaries and pure SQL queries as optimal as possible. I have done it only for tv channel group list, but now it takes 2.5 seconds (instead of 80 seconds originally) for 4600 channels. I think this is an acceptable time i can live with ;) mm and gibman (and maybe other MP devs?), please check the patch and tell your meanings before i apply it on all other places working with channel lists. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
Submit: code patches (MediaPortal/TV-Server/etc.)
optimize listview controls filling in TVSetup - Channel list for groups
Contact us
RSS
Top
Bottom