As Michael says
here ... "It's a trade-off" ... ( which has the same irritable sensation of a bug bite
)
"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."
-------
On a user perspective, this is a very big trade-off because it affects the front door to their gallery of pics.
Am I correct to presume that this was a trade-off for providing the Group by Member / Sort by Feature?
Or was the show last photo feature going to be removed anyway to improve performance?
I understand, Chuck, that you don't consider this a bug support issue, so would you be so would you be so kind as to move it to the Discussion or Suggestions Forum?
~ Mark
I get this creepy pestering feeling replying to a 'Not a Bug' Thread in the Bug Forum