<div dir="ltr">Can't say that I've ever seen that behavior before using sqlite or mariadb in my environment. Unless the database is absolutely massive or the storage is abysmally slow, I highly doubt it is the database. It is unlikely to be PHP either, though without additional context it may be a configuration issue with either ZendTo, PHP, or the OS that could contribute to the slowness.<div><br></div><div>It's been a while since I've dug into situation specific application and database performance monitoring, however there are commercial and open source solutions that may be applicable (Dynatrace, New Relic, OpenTelemetry, etc.), however I can't speak to how easy those are to get set up or how useful the information is once it is... I'd say first say let's troubleshoot the environment ZendTo is running within.<br><div><br></div><div>What's the OS? Are you running on low powered hardware, such as a Raspberry Pi or other SBC where the hardware itself could be contributing to the issue? Have you checked the logs for PHP or the web server for any errors? How do you have CAPTCHA configured (pickup.php has several calls related to it)? Is the slowness consistent with any user from any location, or are there situations where it is not slow? Have you verified that other system settings are properly configured, such as DNS resolvers, interface details like MTU (1500 is usually the default, but some ISPs and cloud hosts require something lower), etc? How big is the sqlite database? Is the storage that you're running the ZendTo application and database on local to the server, or remote using NFS, iSCSI, something more exotic or using FUSE, etc? Do you have SELinux and/or auditd enabled, or applied any "security profiles" such as CIS, etc?</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jan 10, 2024 at 7:48 AM Samuel McCarthy via ZendTo <<a href="mailto:zendto@zend.to">zendto@zend.to</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-4593537790832584131">
<div lang="EN-GB" style="overflow-wrap: break-word;">
<div class="m_25269178903759024WordSection1">
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Has anyone had issues with slow page loading on the pickup part of Zendto (pickup.php)? We seem to have one user whose uploads take a very long time to load when others navigate to pick them up. They do load in the end, but it takes a good
5 minutes. The files aren’t that large, and it doesn’t seem to happen on all their dropped off files. Anyone have any ideas of how to diagnose what I assume is slow PHP queries/slow sqlite queries? <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Kind regards,<u></u><u></u></p>
<p class="MsoNormal">Sam<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><b><span style="font-family:Arial,sans-serif;color:rgb(225,225,225)"><u></u> <u></u></span></b></p>
<p class="MsoNormal"><b><span style="font-family:Arial,sans-serif;color:rgb(225,225,225)">Sam McCarthy</span></b><span style="font-size:12pt;font-family:Calibri,sans-serif;color:rgb(225,225,225)"><u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
ZendTo mailing list<br>
<a href="mailto:ZendTo@zend.to" target="_blank">ZendTo@zend.to</a><br>
<a href="http://jul.es/mailman/listinfo/zendto" rel="noreferrer" target="_blank">http://jul.es/mailman/listinfo/zendto</a><br>
</div></blockquote></div>