You only need to index common where statements that are used often. Review the query log at the bottom of your pages and check for CB tables then see queries that are repeated or very large and add an index for them if possible.
If I recall correctly you're the user with millions of users on your site. There is no workaround to improving performance. You absolutely must profile your site. This is the only way to find bottlenecks and then fix them. Using xDebug Profiler for example can help profile on a page by page basis (run it on slow pages) to see what's taking forever and take you straight to the lines of code causing the slow down. This is a task that "scale-ability" teams normally handle so it's very possible you need to contact an expert team to help performance optimize your site.
Joomla and any Joomla extensions will require custom changes to fix your scale needs. They all have a "normal" range and you're outside of it and will require scale-ability changes to improve the performance. Even if you have just Joomla and nothing else you'd hit brick walls in performance due to not implementing scale-ability changes.
Simply changes like locking page limit to 25-50 entries only, disabling various Searches (often heavy), etc.. can improve on this performance greatly. You need to find what pages are slowing you down exactly and then profile them.
There's a good read on this for Joomla found below.
At this time I've never simulated a website with millions of users so I don't really know what more to suggest.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: edmundcheong
Yup you are right, I am the one with the million users, but technically only 5000++ will be active who will be updating the other user records..
The remaining are just records, and they don't login.. Seriously, I believe it's got to do with hardware, I have 6gb of memory, and I need to get my indexes correct.. I can't index everything as I need enough memory to swap the proccesses..
krileon
