I'm using a multi-site OpenCart platform with a HostGator VPS and cannot seem to get the First Byte Time improved on [url removed, login to view] . I have a CDN through [url removed, login to view] , and have multiple caching plug ins that don't seem to help.
I've asked around in the OpenCart community to see what a solution may be. It may be due to the large SQL database I'm running, or my VPS/SQL is not configured correctly. One site has 12,000 products and 12,000 images (images are being handled by the CDN just fine). The 2nd and 3rd sites haven't even been started yet, and will carry another 25k products between them. All sites on the multi-site platform I believe share the same SQL database. This also needs to be taken into consideration.
The job would be to optimize the back end processing via my VPS/SQL/OpenCart-Plug-ins so my first byte time is improved and my site loads in under 4 seconds (or close). Currently the main page of the site takes 12 seconds which is way too long. This will need to be verified through webpagetest.org.