Announcement

#1 2022-04-10 18:12:55

BigIsland270972
Member
Norway
2022-03-15
374

[resolved] Why is loading search.php so sloooow?

Hello/Hi/Greetings,

I have 700 000 ++ images in my database, but why does it take 20-30 seconds to load the page?

I've been testing php cache script but can't get it to work properly.

Piwigo URL: https://www.arkivfoto.net/search.php


    Piwigo 12.2.0 Check for upgrade
    Operating system: Linux
    PHP: 7.4.28 (Show info) [2022-04-10 16:12:25]
    MySQL: 5.5.5-10.3.28-MariaDB [2022-04-10 18:12:25]
    Graphics Library: External ImageMagick 6.9.10-86
    Cache size 1570.7 Mo   calculated 2 weeks ago Refresh

Activated plugin list 65

    Add tags mass
    Additional Pages
    Admin Messages
    Admin Tools
    Advanced Menu Manager
    AStat.2
    BanIP
    Batch Downloader
    Batch Manager Prefilters
    Batch Manager, Added By
    Batch Manager, Photo Description
    Block search
    Contact 1 menu
    Contact Form
    Copyrights
    Download by Size
    Download Permissions
    Exif View
    Extended Description
    External Reference
    FCK Editor
    Force HTTPS
    Fotorama
    Grum Plugins Classes.3
    GThumb+
    Language Switch
    LocalFiles Editor
    Look_like_gbo2
    Manage Properties Photos
    Meta Open Graph
    NBC ThemeChanger
    NBM Subscriber
    No Stats For Robots
    OpenStreetMap
    Perso About
    Perso Footer
    Personal Favicon
    Photo Update
    Physical Photo Move
    Posted Date Changer
    Prepaid Credits
    prevnext
    Private Share
    Properties Mass Update
    PWG Stuffs
    Reply To
    rightClick
    Rotate Image
    RV autocomplete
    RV Thumb Scroller
    Scroll To Top
    Search links
    Social Buttons
    Social Connect
    SortOrders
    Subscribe To Comments
    Tag Groups
    Tag Recognition
    Theme Switch
    Thumbnail Tooltip
    Title
    Update Album
    URL Uploader
    User Collections
    VideoJS


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

#2 2022-04-11 01:14:24

erAck
Only trying to help
2015-09-06
2032

Re: [resolved] Why is loading search.php so sloooow?

Main bottle neck seems to be the >15000 tags/keywords it loads (for Search keywords), along with determining how many items have each assigned. See the source of the generated page.


Running Piwigo at https://erack.net/gallery/

Offline

 

#3 2022-04-25 17:08:15

BigIsland270972
Member
Norway
2022-03-15
374

Re: [resolved] Why is loading search.php so sloooow?

Removed TAGS alltogether in search.tpl.
Search loading way faster :-)


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact