HTML Logo by World Wide Web Consortium ( Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS. ocPortal 9 is superseded by Composr 10.

Head over to for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.

Database optimisations for ocPortal 9.0.5

Login / Search

 [ Join | More ]
Item has a rating of 5 (Liked by JeanLiked by FletchLiked by sholzyLiked by Robbie Goacher)  
#95179 (In Topic #18950)

Hi all,

We optimised a few scenarios in ocPortal 9.0.5 via new database indices. However, existing installs would not automatically benefit from these so we are attaching a script to create them.

These scenarios were optimised:
  • Thousands+ of gallery images or videos
  • Thousands+ of forum topics created per month (comment topics could do this)
  • Thousands+ of members with searchable Comcode custom profile fields
  • Generally a very large amount of searched content

» Download: execute_temp.php (4 Kb, 216 downloads so far)

Upload the script and load http://baseurl/data_custom/execute_temp.php in your browser.

Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Support me on Patreon
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: