the problem with that is theres lots that are 0 so are unseen
this table should be auto proned at say 10 notifications kept per user
this is another thing adding to the database calls
i am having huge speed issues as my site grows
page load speed on first join my site is average 6.7 seconds which for oxwall script is dam good
i am running 4gb memory cashe and max sql cashe
i am adding mod pagespeed and APC cashing in the next week or so to my server and hope to get below 5 seconds
i have one account with 1000 friends and lots of notification page load times go up to 10.3 seconds
and another account with 2000 friends and bucket loads of notifications page load time goes to 15 seconds
so by the time a user get to 4000 friends the site will become useless to that user
and the sql requests from all users will crash my server
this is a huge issue and needs to be fixed
until it is i can manual prone that databass and il have to work out how to limit users friends to a limit of 500
notifications need to be auto proned
im chat needs some way of fixing sql request
ether owall has a cashe system and cashe the users friends which in time will not work due to the size it would get to
or make the im not reload as a user goes from page to page as other site do ie facebook
and limit the amount of online users in the list to 30 or 40 with a view more online friends button
load impact your site and see the sql requests go through the roof
https://loadimpact.com/
WARNING DO NOT RUN THIS ON A SHARED SERVER
THE FREE TEST THAT SIMULATES 150 USERS WILL SHUT YOUR SERVER DOWN ALMOST INSTANTLY