Hall of Fame

[dtiberio]

around 10% of my requests to the search pages are very very slow.

I checked the mysql server during this time and there are no pending queries.

I also tested other software hosted on the same server, and the pages served up fine, so I think the problem is not the mysql server or the httpd server.

what might cause the pages to not server up quickly? it might take 10 seconds to get the page.

[PHPVibe A.]

The query itself it's pretty large there, plus all the joined tables, we will lighten it in this upgrade, was one of the discussion we had on the last meeting, we want to remove some joined tables for the high-impact pages and also break search and tags to two different coms.

[dtiberio]

I suspect the problem is here, or maybe with the js files. these css files are way too large. you have to request the html page, then the css and js files. if the html page has css code or js code in it but the js files and css files have failed to load yet, then it may completely stall the display of the html page.

the js files probably make calls to other js files, but they don't get loaded in order. when you load html pages, and they request js files, the js and css files are returned in a random order based on how quickly the server responded.

idle servers are only going to handle 16 or so requests at a time. if your total html, images, css, and js files are over 16, then you are going to have problems with loading content.

my css files are under 5,000 bytes. you should keep them as small as possible. make sure you remove and css code that isn't avctually being used by the html.

-rw-r--r-- 1 apache apache 26253 Apr 14 13:12 responsive.css_
-rw-r--r-- 1 apache apache 27640 Apr 14 13:12 responsive.css
-rw-r--r-- 1 apache apache 27467 Apr 14 13:12 plugins.css
-rw-r--r-- 1 apache apache  4350 Apr 14 13:12 lightbox.css
-rw-r--r-- 1 apache apache  2941 Apr 14 13:12 index.html
-rw-r--r-- 1 apache apache 19303 Apr 14 13:12 font-awesome.css
-rw-r--r-- 1 apache apache 49653 Apr 14 13:12 bootstrap.css
-rw-r--r-- 1 apache apache 66686 Apr 14 13:12 vibe.style.css_
drwxr-xr-x 2 apache apache  4096 Apr 14 14:35 font
-rw-r--r-- 1 apache apache 76586 May  4 20:53 vibe.style.css

[dtiberio]

here is an example. I just installed the software perhaps 48 hours ago, and I have made 982 requests to the lightbox css file, which is way to excessive. it should only have called it 1 time then cached it. same with the other css files.

maybe there is a misplaced cache control tag somewhere.

[root@digitalocean2 phpvibe_pro_3.6]# grep lightbox.css /etc/httpd/logs/access_log|grep 74.111.12.71|wc
    982   17694  224339

[dtiberio]

just an FYI people are saying that there is a problem with firefox not caching documents. so i think it is a firefox issue.

[PHPVibe A.]

Here is the thing, we have to release all files uncompressed so people can edit them.
When you finish that, you can compress and/or combine every css and js file.
Also easily move them to a subdomain (so it acts as an cdn) because this way you can get an faster page load http://www.phprevolution.com/forum/troubleshooting-issues/coding/msg17632/#msg17632.

[dtiberio]

I moved the css files to my cdn.

however, those files are way too large. you should reduce them in size. not using compression software, but by removing anything in the css files that are not actually being used by the site, and by making more efficient use of css commands.

make sure that anything in the css and js that is not used is removed.

try to combine as many css definitions together as possible.

[PHPVibe A.]

Best choice would be move away from bootstrap to an simpler and lighter framework but this would be an pain for those which already have heavy customization.

Next themes will be lighter, uikit or pure.io based.