@wp
Correct, but this something I know. That's why I always keep all photo's outside the database.
In the database resides only a n image-name and a part of the directory where resides the photo.
However, on the harddisk I have 3 similar directory
FolderX\originals\<dir-reference in database>\<photo-name in database>
FolderX\slides\<dir-reference in database>\<photo-name in database>
FolderX\thumbs\<dir-reference in database>\<photo-name in database>
When creating a overview in a grid, I use thumb-presentation
When creating a full-screen-image I uses the slide-option
When looking to the reall image (can be 36 MP) I use the original option.
Tho construct the real path, I have just to choose between originals, slides or thumbs.
This work extremely quick.
Of course, the select has his limitation where I only permit a max of 100 images...
Ok, all photo's are kept 3 times. One with full size, one with a 1024-768-base and one with 250-250-base.
So we talk about 35 MP or higher, ¹200Kb and ±6Kb
For the moment I own about 130.000 images and I once wrote a program to maintain, order, tag, ... this with PHP and HTML. Program is still used and runs now for more than 15 years ... Now I would like to have an exe that runs without HTML, PHP.
But thanks for the useful info