|
It's an issue of efficency; in the prior version of PhotoPost we did the main query and then if you were viewing thumbnails a second query for each member being displayed to find the latest thumbnail. This means that the showmembers page with 30 members would result in 30 additional queries per page. Using the method, we save the 30 queries, but loose the last photo uploaded thumbnail. It's a trade-off.
MySQL does support sorting columns during the GROUPing of records, by grouping the records from the photos table, we save any processing of members who have no photos at all.
__________________
Please do not PM me for support or sales questions. Thank you for your understanding. |