ISSUE SUMMARY:
We have a fairly large community website with over 14000 user accounts, over 55000 photos etc. When many logged in users visit user profile pages at the same time, our server gets exceptional overload (we have a strong dedicated server, so this shouldn't happen). The MySQL database gets lots of requests like this:

| 34051 | xxxxxx | localhost | xxxxxx | Query | 0 | Waiting
for query cache lock | SELECT * FROM `jos_community_photos` WHERE
`albumid`='2380' ORDER BY `ordering` ASC, `created` DESC |
| 34115 | xxxxxx | localhost | xxxxxx | Query | 0 | Waiting
for query cache lock | SELECT COUNT(*) FROM `jos_community_photos`
WHERE `albumid`='2380' |
| 34184 | xxxxxx | localhost | xxxxxx | Query | 0 | Waiting
for query cache lock | SELECT COUNT(*) FROM `jos_community_photos`
WHERE `albumid`='2380' |
| 34235 | xxxxxx | localhost | xxxxxx | Query | 0 | Waiting
for query cache lock | SELECT COUNT(*) FROM `jos_community_photos`
WHERE `albumid`='2380'

It looks like Jomsocial is not optimised in this area. Please advise ASAP. |
STEPS TO REPLICATE:
1. As a registered user visit any user page on our site, ie. www.tanie-loty.com.pl/profil/6279ewa . You need to be logged in, so the pages won't be cached.

RESULT the page loads very slowly, sometimes it takes more than a minute.
EXPECTED RESULT the page should load quickly
BROWSER any

Hi,

that repeating query from:
/components/com_community/models/photos.php at getPhotos function.

please try this:
open that file at getPhotos function around line 343 change the code from

$query = 'SELECT COUNT(*) FROM ' . $db->quoteName('#__community_photos') . ' '

$query = 'SELECT COUNT(id) FROM ' . $db->quoteName('#__community_photos') . ' '