ISSUE SUMMARY:

I have installed New Joomsocial, works great. It works fine until i starting importing users, its become slower and slower. But now after loading some time it gives 500 internal server error on front page, however members page works fine.

i have installed joomsocial on VPS of godaddy
192.169.189.1/~admin/

the above links works great. dosen't matter how many users there are in database,

But when i try to access joomsocial page. due to large amount of users, it became very slow and now even the page is giving 500 internal error after loading for some time.

192.169.189.1/~admin/index.php/jomsocial

currently there are 4000+ users imported from ning, and this is giving this issue.
but there are total 100000+ users to import in to this database.

How to manage this huge and enormous amount of users without site being going down ??

STEPS TO REPLICATE:
1
browse to page 192.169.189.1/~admin/index.php/jomsocial
2
3
4
5
RESULT
gives 500 internal server error after loading some time.
EXPECTED RESULT
should show page with under reasonable time.
BROWSER

Hi Val,

On backend I get this error :

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 2 bytes) in /home/admin/public_html/libraries/joomla/database/driver/mysql.php on line 464