Comment to 'The need for speed'
  • Hello @gkuhnert !

    Could you please share your Studio->Dashboard->Server Audit area? And please specify what caches did you enable?

    • The screenshot I shared was from your website... so 100% not just my site... But for sake of argument, see below. As per the screenshot, my bet is on the sheer number of sql aueries. It feels like it is inherrently doing a whole lot of stuff thats causing the poor performance.

      For the record, GZ compression is on, and local cache options are 100% correct.

      Host Tools
      Requirements
      PHP: 
      version = 8.3.23 - OK
      allow_url_fopen = On - OK
      allow_url_include = Off - OK
      magic_quotes_gpc = Off - OK
      memory_limit = 128 MB - OK
      post_max_size = 64 MB - OK
      upload_max_filesize = 64 MB - OK
      register_globals = Off - OK
      safe_mode = Off - OK
      disable_functions = exec,system,passthru,proc_open,proc_nice,ini_restore - OK
      php module: curl = curl - OK
      php module: gd = gd - OK
      php module: mbstring = mbstring - OK
      php module: json = json - OK
      php module: fileinfo = fileinfo - OK
      php module: zip = zip - OK
      php module: openssl = openssl - OK
      php module: exif = exif - OK
      MySQL: 
      version = 10.5.27 - OK
      Web-server: Apache
      rewrite_module - OK (mod_rewrite is active: request reached PHP (even if 404 status))
      OS: 
      Linux 5.14.0-503.16.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Dec 13 01:47:05 EST 2024 x86_64 
      Hardware: 
      Hardware requirements can not be determined automatically - manual server audit may be required. 
      Site setup
      UNA version = 14.0.0 - OK
      Files and folders permissions - please click here to find out if permissions are correct.
      ffmpeg - 
      ffmpeg version 4.4-static ffmpeg-url  Copyright (c) 2000-2021 the FFmpeg developers
        built with gcc 8 (Debian 8.3.0-6)
        configuration: --enable-gpl --enable-version3 --enable-static --disable-debug --disable-ffplay --disable-indev=sndio --disable-outdev=sndio --cc=gcc --enable-fontconfig --enable-frei0r --enable-gnutls --enable-gmp --enable-libgme --enable-gray --enable-libaom --enable-libfribidi --enable-libass --enable-libvmaf --enable-libfreetype --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-librubberband --enable-libsoxr --enable-libspeex --enable-libsrt --enable-libvorbis --enable-libopus --enable-libtheora --enable-libvidstab --enable-libvo-amrwbenc --enable-libvpx --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxml2 --enable-libdav1d --enable-libxvid --enable-libzvbi --enable-libzimg
        libavutil      56. 70.100 / 56. 70.100
        libavcodec     58.134.100 / 58.134.100
        libavformat    58. 76.100 / 58. 76.100
        libavdevice    58. 13.100 / 58. 13.100
        libavfilter     7.110.100 /  7.110.100
        libswscale      5.  9.100 /  5.  9.100
        libswresample   3.  9.100 /  3.  9.100
        libpostproc    55.  9.100 / 55.  9.100
      Hyper fast Audio and Video encoder
      usage: ffmpeg [options] [[infile options] -i infile]... {[outfile options] outfile}...
      
      Use -h to get full help or, even better, run 'man ffmpeg'
      if you dont know if output is correct then manual server audit may be required.
      Mail sending - click here to send test email
      Cron jobs - 
      no crontab for una
      if you are unsure if output is correct then manual server audit may be required
      Last cron jobs execution - 3 Aug 2025 9:56:01 pm
      Site optimization
      PHP: 
      PHP accelerator = ZendOPcache - OK
      PHP setup = fpm-fcgi - OK
      MySQL: 
      key_buffer_size = 128 MB - OK
      max_heap_table_size = 16 MB - OK
      tmp_table_size = 16 MB - OK
      thread_cache_size = 151 - OK
      Web-server: 
      User-side caching for static content - click here to check it in Google Page Speed
      If it is not enabled then please consider implement this optimization, since it improve perceived site speed and save the bandwidth.
      To apply this optimization you need to have expires_module - OK (Detected Expires or Cache-Control header via HTTP on static asset)
      Server-side content compression - can be checked manually or in "Page Speed" tool build-in into browser.
      If it is not enabled then please consider implement this optimization, since it improve perceived site speed and save the bandwidth.
      To apply this optimization you need to have deflate_module - OK (Detected compression (gzip/deflate) via HTTP headers on static asset)
      UNA: 
      DB cache = On (Memcached based cache engine) - OK
      Pages cache = On (Memcached based cache engine) - OK
      Page blocks cache = On (Memcached based cache engine) - OK
      Templates Cache = On (Memcached based cache engine) - OK
      CSS files cache = On - OK
      JS files cache = On - OK
      Compression for CSS/JS cache = On - OK
      Manual Server Audit
      Some things can not be determined automatically, manual server audit is required to check it. If you dont know how to do it by yourself you can submit Server Audit Request.
      

      image_transcoder.php?o=sys_images_editor&h=2794&dpx=2&t=1754222544

      image_transcoder.php?o=sys_images_editor&h=2795&dpx=2&t=1754222728

      • Thnx for the details. Well, from the provided server audit I may see that the memory_limit param's value is too low. It would be good to have the 512Mb at least.

        • Changed it, and it made exactly 0% improvement. I monitor server logs, and there were no pages getting tripped by the memory_limit value. As said before, the root cause appears to be the sheer volume of SQL queries (and associated data processing). Why do we need literally thousands of queries to render a page? Something inherrently wrong in that part of Una.