So im not sure what to do in order to fix this. We have a large forum of over 1 million members which i know is large. Well recently we upgraded to phpbb3 and got the newest plugin and installed it all. Well now if you try to edit a members subscription or a new member joins the site just sits there after hitting submit for a few minutes before it even starts loading. I believe its going thru every member on the site. Is there a way to speed this up?
Sounds like a server load issue- are you on a dedicated server? with 1mil, you had better be on something quite powerful. David
because the phpbb3 plugin uses username in queries and its not indexed by default on phpbb3, adding the index fixed the issue