- Thread starter
- #21
i was disappointed from possibilities of gentle.net - no SQL in SQL, no suffixes for operators (like SELECT DISTINCT), 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.
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.