If you are one of the fortunate website of owners of a high popularity Clip-Bucket website, you might have found yourself struggling with a slow website due to the high traffic you get. There are many ways of optimizing a website such as code, database and server optimizations. Today I will show you a very simple trick that will relieve load on your database. Tested on v2.6.
A customer of ours started a Clip-Bucket website and in a matter of weeks, it started getting a serious amount of daily unique traffic (thousands). They immediately needed to upgrade to a very powerful Cloud Server to handle all this traffic. Even though the server had a lot of specs, the site was running kind of sluggish. By analysing what queries consumed the most resources, it was found out that the cb_sessions table was eating a considerable amount of resources. More specifically, there was an index for “session_id”, but the column being used the most was “session”. Creating an index for “session” did the trick and dramatically increased the speed of the website.
1. Open phpMyAdmin from your cPanel
2. Navigate to the structure of the cb_sessions table
3. Find the “session” table and click on Index
4. Click OK to execute the query
1. To make the table an Index table, execute the following command:
ALTER TABLE `cb_sessions` ADD INDEX(`session`);
And there you go! If you get stuck at any step or would like further clarification, please let me know! I always try to reply to comments ASAP. Moreover, let me know how this helped you in your website.