Not more needed to use centralized SQLIte DB in MP1... But without any guarantee... Same is for Kodi, it is also without any support or named as "stable"...Added 3 lines in the configuration file
Maybe, but this function is a long time. And it works flawlessly. I do not know why it has not yet been carried to the settings. And have not removed the status of "advanced (complicated) and experimental" and replaced it with a stable.Same is for Kodi, it is also without any support or named as "stable"...
I can speed up the MySQL on remote: from 6 sec to 4-4.5 sec on same folder. This is not a big result but better than nothing.I added 350 files to a network folder and added some statistics rows to my dev build.
Here is my test result:
MySQL on remote: GUIVideoFiles:LoadDirectory is finished in 6060 ms
MySQL on local: GUIVideoFiles:LoadDirectory is finished in 2561 ms
SQLlite on remote share: GUIVideoFiles:LoadDirectory is finished in 2303 ms
SQLite on local: GUIVideoFiles:LoadDirectory is finished in 1302 ms
It means the MySQL is slower then SQLite but the big difference if the database is in remote.
Maybe on the server, which indexes to correct? Or where there is a bottleneck? Maybe it makes sense, take all possible data, and then it locally, from memory select?I can speed up the MySQL on remote: from 6 sec to 4-4.5 sec on same folder. This is not a big result but better than nothing.
I mean that we should abandon the many small requests in favor of one big one. And then to process the data from it. At least when you open the plug-in, or entering into a new folder.The client caching is bad think because we want to use many clients at same time.
|Using TMM, How to Stop Importer From Going to The Movie Database for Data||General||1|
|H||MP2 database won't keep in synch with recordings||General||8|
|F||How to reset tv recordings database||General||5|
|A||Synchronizing client databases||MediaPortal 1 Talk||10|
|R||Problems accessing MySQL database remotely||MediaPortal 1 Talk||0|
|Music Database Error||Listen Music||1|
|R||[solved] Files moved to new location - Easy way to update database?||My TVSeries||7|
|R||Files moved to different location - Easy way to update database?||Moving Pictures||2|
|H||[solved] Video database genres, sort titles and collection thumbnails||Newcomers Forum||12|
|G||MP1 TV Server "failed to upgrade the database" using MS Sql Server||Installation, configuration support||3|
|D||PC rebuild & MP2 upgrade - how to preserve database and settings?||General||1|
|H||MP1.21F video database scan, can it be scheduled to automatically run in background||General Support||5|
|D||Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2||General||9|
|Sync databases by Media Sync Service||MediaPortal 1 Talk||26|
|W||[solved] MP 1.20 Video IMDB no showing plot||General Support||129|
|How to get My Films working in MP 1.20||My Films||5|
|C||How well can MediaPortal handle 10,000+ recordings?||MediaPortal 1 Talk||3|
|D||Single Seat Install - can another single seat use the same databases?||Installation, configuration support||1|
|P||[Resolved] Missing column in database||My TVSeries||7|
|M||Need advice on writing plugin that modifies EPG database||TV-Server||2|
|Skinning Online Videos question||OnlineVideos||2|
|A||[solved] How to Play All Videos in a List||watch/edit Videos||3|
|O||1.25.0 Codecs and Video Format for PlayStation 2||Codecs, External Players||0|