The past couple of years has seen drastic web performance improvements mostly due to:
virtually all website hosting have SSD
website hosting now have more memory
internet connections now much faster
…mostly because I have quite a complicated PHP update routine that:
downloads three XLS Spreadsheets from another host
converts from XLS to CSV format
deletes six old MySQLi database tables
updates the relevant tables from the CSV files
removes duplicates and empty columns
creates indexii to improve search performance
The above operations takes 16.19 seconds on a five dollar VPS with 1 GB of memory and 66.94 seconds on my local computer using 8 GB memory and a 100 mByte internet service provider. Both OS are using Ubuntu 18.04.
Surely with such a vast elapsed time difference…
Another reason is that I use AJAX to search tables with about 20,000 records and the response is nearly instant.
Corrected drive acronym from SDD to SSD.