Firstly, am hosting my site on Siteground on their shared hosting plan. Due to my huge traffic I was blocked by siteground and advised to upgrade to a dedicated server which I did. I subscribed to their least powerful dedicated server with Processor(Atom Dual-Core 330 1.6 GHz)
Then I started having problems with the site even after moving to a dedicated server such as my site showing Error 500( Internal Server Error), which was due to the huge traffic because I do have 100-200 people online at once. I complained to Siteground. They indicated that their cpu processor cannot fully handle my traffic. I have uploaded a saved webpage in a ms-word form containing the discussion between Siteground's technical Assistant and I regarding my problem. Please I advise you go through it in order to understand the genesis of the problem.
To this extent, I want you to optimize and manage my MySQL database and PHP scripts as suggested by siteground's technical assistant in a way that when I have huge traffic on my site, it wouldn't show Internal server error.