Posts by Klojum

    vpeter: Disable the optimizer_search_depth parameter via a hashtag in my.cnf.

    I thought 0 as value would also work but it does slow down things.

    I still get hiccups sometimes but apparently the MySQL Workbench tool is at fault there.

    The query is now returning data quickly:

    6255 records in 0.173s

    9320 records in 0.224s

    Seeing the worldwide sales and overall support of the various Raspberry Pi devices, they'll be around quite a bit longer than today.

    In terms of PC hardware, all new(er) Intel should okay. AMD Ryzen still has it hiccups and challenges in Linux. Be aware of hardware requirements if you also want to do Netflix (via Windows or otherwise).

    As an unwritten rule, try not to spend more than 150-200 euro each time you want new HTPC hardware (unless you have deep pockets). Technology comes and goes fast.

    DEMAND to REPAIR (ADD) in the NEXT version 9.0.XX

    Gee, which universe are you coming from? Or did you simply forgot to take your ADHD medicines today?

    Tell us, why should we even start paying attention to someone that is obviously delusional about the way that LibreELEC creates and supports its product?

    Even if your "bug report" concerns a valid problem, the way in which you are presenting your case is nothing less than total obnoxious talk coming from someone that lacks any form of empathy with our LibreELEC software and its users. Also insulting other people on this forum will not get you popularity points. Personally, I would kick your sorry ass right away off this forum. But LibreELEC is a team, so we'll have a vote on it later on.

    Simply put: you are in no position to demand ANYTHING from us or other forum visitors. I suggest you really tone down your unacceptable attitude, or your stay at this forum will be an extremely short one.

    After the import, I would be guessing the mariadb cache isn't big enough the whole database and thus for "that query" to go fast, but maybe it is?

    What if you run the query 5 times or so, 1 every minute. Is it constantly resulting in the 6.789s regions?

    Any assistance on this

    Is there a fire somewhere? Bumping one's own thread under 24 hours is not chique as per forum etiquette.

    feel as if there are frames being skipped.

    Sports in video, especially sports involving some type of ball, are not suited for 24-30fps videos. 50-60fps is the minimum IMO.

    I don't know what happened in the latter part of your log file, PVR is not really my department.

    Roughly 6.8 seconds for 8230 for that view is much better than 30 seconds. On a PC+SSD setup it's still sluggish (MySQL 5.x results return instantly), on a RPi-like device with SQLite, it's "just about acceptable" for me. Five seconds is a mental barrier. But it should still go faster IMO.

    So I'd say it's an improvement, if all the other query stuff still works as advertised.

    OpenELEC is basically E.O.L. after 2 years now. It lacks all the necessary system and security updates of those years.

    LibreELEC is 'forked' from OpenELEC and fully up-to-date, with various official builds, community builds and nightly builds and all.

    Netflix is still a work in progress but the basics are working, A Hulu add-on is currently not in the works.

    For Netflix, a Raspberry Pi 3B+ is recommended if you are talking RPi devices.

    An "old laptop" and Netflix... How old is it, and which specifications does the laptop have?

    "Long term viability" is an ugly term in the computer land. Don't expect to buy computer hardware that will last you 5-6 years. New technology can come and go quickly. Think of things like 4K, HDR(10+), h265/HEVC, 10 bits for video only. Various audio options are also thrown into the mix.

    Code
    16:12:19.695 T:1945550960  NOTICE: ADDONS: Using repository repository.exodus
    16:12:19.695 T:1945550960  NOTICE: ADDONS: Using repository repository.xbmc.org
    16:12:19.695 T:1945550960  NOTICE: ADDONS: Using repository repository.lambda
    16:12:19.695 T:1945550960  NOTICE: ADDONS: Using repository superrepo.kodi.helix.all
    16:12:19.695 T:1945550960  NOTICE: ADDONS: Using repository repository.xbmchub
    16:12:19.696 T:1945550960  NOTICE: ADDONS: Using repository repository.kodi.game
    16:12:19.696 T:1945550960  NOTICE: ADDONS: Using repository repository.libreelec.tv
    16:12:19.696 T:1945550960  NOTICE: ADDONS: Using repository repository.kodibae

    Now why are you doing this...? Visitor #2,892,735 that forgot to read the forum rules that explain that LibreELEC/Kodi wants NOTHING to do with video piracy, and here you have a Kodi setup with several repositories and add-ons for illegal video viewing.

    Support stops here. You can show yourself out.