This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Speeding up page load


avatar
lalawren 0
From: -
Speeding up page load

Hello!
I just transferred a large Storyteller site to a dedicated server in hopes of speeding up delivery of the site. The site contains a large amount (2-3 Mb) of news stories, a dozen or so are shown on the first page. Is there anyway to optimize or tweak the database for faster delivery?

or any resources for optimizing MySQL?

The site will continue to grow with forum postings and more news and articles

the site is :  http://www.retirement-retirement.com

Thanks!

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic


1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

Cut & pasting from where? Please describe everything you did and the involved programs as detailed as possible, after I need to be able to reproduce the problem on my local test installation.
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

not to my understatding.

using cut and paste we have the same problem
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

Are you using the email import feature to import news from a pop3 account to the queue? Can you please explain what do you mean with drop and drag?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

I belive so, when I drop and drag or when someone submits a new article.

this is a little of what someone just submited

Wall Street Institutions pay billions of dollars annually to convince the investing public that their Economists, Investment Managers, and Analysts can predict future price movements in specific company shares and trends in the overall Stock Market. Such predictions (often presented as �Wethinkisms� or Model Asset Allocation adjustments) make self-deprecating investors everywhere scurry about transacting with each new revelation. �Thou must heed the oracle of Wall Street�� not to be confused with the one from Omaha, who really does know something about investing. �These guys know this stuff so much better than we do� is the rationale of the fools in the street, and on the hill (sic).
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

I tried now multiple things but cannot reproduce this on any of my installations. Is this only happened on news stories from the news queue?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

I think plain
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

What do you mean with drop and drag? Cut&paste from another program? Are you using the plain or WYSIWYG editor?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

I use a firefox browser. " Last 5 Stories In Queue"
i had this problem with every article along with what I drop and drag.
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

I am unable to reproduce this problem.

Which browser are you using? Did you use another program (such as Microsoft Word) to edit the text first?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

Fron page yes. every page and tittle.
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

Are these chars visible on the front page or only in the admin section?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

It is set to "no" on all 3 sites. I didn't have to change anything
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

Try the following:
Set "Allow HTML only in HTML formating mode:" to "No" in Other/Config

Let me know if this fix your problem
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

Hand posting
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

When that happens? Are you using the "News Import" feature to import articles over RSS?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

Thanks again I have a couple of small issues when you add a new article
sometime the article does this. One is

"environment�i.e., an FDIC insured bank account. Risk comes in various forms, but the average investor�s primary concerns are �credit� and �market� risk� "

It sometime adds symbols mainly when you use a '.

I believe it to all three sites

 www.investment-investment.us
 www.business-business.biz
 www.retirement-retirement.com



Thanks for all your help.
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

I think that was it! Yeah Smiling Face..!
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

I may found another workaround to speed up the rebuilding of the main page cache. Open index.php and remove the following lines:

if (!$insert[story_html]) 

{
$insert[story_text] = DeChomp($insert[story_text]);
}
if ($insert[story_icon])
{
$insert[story_text] = Icons($insert[story_text]);
}
if ($insert[story_code])
{
$insert[story_text] = Code($insert[story_text]);
}

$insert[story_text] = eregi_replace("\[thumb\]([^\[]*)\[/thumb\]", "<a href="https://www.contentteller.com/javascript:FullWin('thumb.php?img=\1&action=full&section=news')"><img src="https://www.contentteller.com/thumb.php" border="0"></a>", $insert[story_text]);
$insert[story_text] = eregi_replace("\[thumbleft\]([^\[]*)\[/thumbleft\]", "<a href="https://www.contentteller.com/javascript:FullWin('thumb.php?img=\1&action=full&section=news')"><img src="https://www.contentteller.com/thumb.php" border="0" align="left" hspace="10" vspace="10"></a>", $insert[story_text]);
$insert[story_text] = eregi_replace("\[thumbright\]([^\[]*)\[/thumbright\]", "<a href="https://www.contentteller.com/javascript:FullWin('thumb.php?img=\1&action=full&section=news')"><img src="https://www.contentteller.com/thumb.php" border="0" align="right" hspace="10" vspace="10"></a>", $insert[story_text]);

if ($blocks[website_ads])
{
$insert[story_text] = DoAds($insert[story_text]);
}

These lines are two times in the index.php script. Remove both.

Removing these lines will disable the parsing of block code, smilies, and text ads during the rebuild of the main page cache. This will significantly speed up the script, especially with 100 articles on the main page.
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

----------------------------------------------------------------------------
Hello,

My best recommendation is to let the software developer have complete access to your VPS. Beyond that, we could possibly look at a dedicated solution. But that means a higher cost.
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

Did you test when dealing with adding content?

Yes. I think your current VPS environment have a problem with rebuilding the main page cache. The main page cache gets deleted each time after you add new content.

One thing you could try is limiting the numbers of articles on the main page to 10 or 20 articles. To limit the number of articles: cadmin => Other/Websites => Edit => Max. News
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

I have to say I'm frustrated, the server company says their platform runs great that the problem is software. The platform seems to run well and they have very good service. After reviewed them I believe they have the best platform on the market.

The software company says it's software runs great that it's a server platform, I know the software has tremendous success with other sites, and that success would not be attainable with my issues, for my needs I thought and still do believe that it's the best product on the market.

The search engines and many of our better clients have pretty much dropped us because are up time might be 7/24 and the industry is use to 24/7. These events have been constant for over 45 day. It truly is really hurting our business, time involement, and costly.

It's funny because i do believe these are both outstanding products but how do we get a working solution.

The program and server run fine until we add content, and the server is not overloaded. My frustration would end tomorrow if we could only fix the problem.
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

The site work very well until I add new content. I would hate to move again because the last move was so ugly and I believe this server company has a good platform much better than the shared services we came from. Your sites work well, but the problem is when I add new content the main page becomes frozen, the back pages work but at a lower rate. Did you test when dealing with adding content?
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

I just tried your templates with my biggest test database (around 60,000 news). The performance is nearly identically to the original templates. I also cannot reproduce any crash problem.

My best guess is that your current VPS environment is to strict configured. Perhaps your webhosting provider can move your sites to one of the better shared hosting accounts?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

We e-mailed it
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

Thanks Randy. I need more files. Can you send me a zip with all templates and CMS files?
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

We e-mailed it
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

There are only two possibilities:

1) One of your modifications is causing this problem. I could look into it if you provide the requested files (see post #2055) or a full zip with all your modified files.
2) There is a problem with the server configuration.
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

The website that was doing very well

 http://www.retirement-retirement.com is now frozen when I post new articles like the others
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

I have upgraded your php to php 4.4.1 and restored the mysql medium config settings. The SQL database was not the bottleneck, as all threads were idle when trying to load the page. Strace provided some inconclusive results concerning errors loading the template files.
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

I could look whether something in your modified index.php is causing this problem.

Can you send me a copy of your modified index.php and your site_header/news/site_footer templates to office (at-) esselbach (-dot) com?
1 Re: Speeding up page load
avatar
OP 0
From: -
Speeding up page load

the persistant connection is disabled on all the sites
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

the sites still are not loading new articles correctly the webhost
emailed me this.


"Is the "Persistent Connection" option enabled? If this is the case, please disable it. You find this option under Other/Config in cadmin. "

Do this. Again, there are no problems with the host you are on, lite load, and no memory errors within your VPS.

Regards,
Tristan

[root@1750AS9 root]# uptime
16:50:47 up 2 days, 15:35, 2 users, load average: 0.38, 0.56, 0.50
[root@durig /]# cat /proc/user_beancounters
Version: 2.5
uid resource held maxheld barrier limit failcnt
4515: kmemsize 1506776 1601316 5662310 6291456 0
lockedpages 0 0 64 64 0
privvmpages 12852 12992 67950 75500 0
shmpages 142 142 2048 2048 0
dummy 0 0 0 0 0
numproc 19 21 300 300 0
physpages 3577 3654 0 2147483647 0
vmguarpages 0 0 2147483647 2147483647 0
oomguarpages 5675 5752 2147483647 2147483647 0
numtcpsock 9 9 300 300 0
numflock 3 3 180 200 0
numpty 0 0 4 4 0
numsiginfo 0 1 256 256 0
tcpsndbuf 2220 2220 1258291 2097152 0
tcprcvbuf 0 0 629145 1048576 0
othersockbuf 8580 8580 193986 524288 0
dgramrcvbuf 0 0 327680 327680 0
numothersock 10 11 200 200 0
dcachesize 314266 321388 471859 524288 0
numfile 615 626 2560 2560 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 10 10 128 128 0


I don't no if it helps
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

The problems you are experiencing are within the php script itself. This is determined by the fact that each time it is run, a sleeping mysql process is started, with absolutey nothing happening. We cannot trouble shoot or fix it the problem for you as this is a design problem. The server has very little load on it.

Is the "Persistent Connection" option enabled? If this is the case, please disable it. You find this option under Other/Config in cadmin.
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

Two of my sites are still down constatly the server company claims it's


The problems you are experiencing are within the php script itself. This is determined by the fact that each time it is run, a sleeping mysql process is started, with absolutey nothing happening. We cannot trouble shoot or fix it the problem for you as this is a design problem. The server has very little load on it.

Regards,
Tristan
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

That explains a lot. A virtual private server is a virtual server on a shared machine, e.g. you split this machine with other users/websites.

Is my-large.cnf still installed? This configuration is for dedicated servers with 512MB ram and higher. You need to change this either to my-medium.cnf (128MB) or my.cnf-old.
1 Re: Speeding up page load
avatar
0
From: -
Speeding up page load

yes VPS
1 Re: Speeding up page load
avatar
Administrator
1340
From: Vienna, Austria
Speeding up page load

sorry were down, all ten site they say 256k ram.

256MB? This sounds very low for an Intel Xeon class dedicated server. Is this truly a dedicated server or perhaps a virtual private server (VPS)?
Show more

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.