General Support: Show Album Pics more fast (Urgent)

So Andromeda,

You are talking about when you view the thumbnails in a single Album that this is slow? Or the first time you click to go to the individual Picture from an Album? Do you happen to have a link?

Andromeda,

I think the slowness happens because Plogger is counting the comments for each image for the comment display overlay (which would take a long time if you have a lot of comments). There are a couple of quick adjustments that may speed up the process for you. It could also be handled via AJAX, but that would take a bit more work.

Option 1:
Try this. Open plog-functions.php and find the following code for the function plogger_picture_comment_count() (which should be around line 1939 in the beta3 version):
function plogger_picture_comment_count() {
$row = $GLOBALS["current_picture"];
$comment_query = "SELECT COUNT(*) AS `num_comments` FROM `".TABLE_PREFIX."comments`
WHERE approved = 1 AND `parent_id`='".$row["id"]."'";

$comment_result = run_query($comment_query);
$num_comments = mysql_result($comment_result, 0, 'num_comments');
return $num_comments;
}
and change it to read:
function plogger_picture_comment_count() {
$row = $GLOBALS["current_picture"];
$comment_query = "SELECT COUNT(`id`) AS `num_comments` FROM `".TABLE_PREFIX."comments`
WHERE approved = 1 AND `parent_id`='".$row["id"]."'";

$comment_result = run_query($comment_query);
$num_comments = mysql_result($comment_result, 0, 'num_comments');
return $num_comments;
}

Option 2:
If that's still too slow, I would recommend just removing the comment count at the album level by opening 'album.php' in the theme file you are using. Assuming you are using the 'default' theme, you would look for the following code:
$imgtag = '<img id="' . $img_id
. '" onmouseout="document.getElementById(\'overlay\').style.visibility = \'hidden\';"
onmouseover="display_overlay(\''.$img_id.'\', \''.plogger_picture_comment_count().'\')" class="photos"
src="'.plogger_get_picture_thumb().'" title="'.$capt.'" alt="'.$capt.'" />';
and change it to:
$imgtag = '<img id="' . $img_id
. '" src="'.plogger_get_picture_thumb().'" title="'.$capt.'" alt="'.$capt.'" />';

That should significantly speed up the album display time, although you would lose the overlay effect showing the number of comments. Hopefully we can address this issue for large galleries (either many images, collections, albums, or comments) with a simple total number of children elements in the database (would no longer have to count all the database entries, just pull the number from a single database column).

Hope that helps as a stopgap in the meantime.

Hello Again

Is very strange... I modifed the "function plogger_search" for find results only from CAPTIONS.

Well... now, If I search something, plogger IS VERY VERY VERY FAST !!!

Why search function can be so fast, and view pictures of albums so anynoing slooowwwwwwwwww?

Sugestions?

Thank you sidtheduck!

You really resolved my problem very fast :)

I love you and I love plogger too !!!