Comment to 'The need for speed'
  • 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.