Re: Troubleshooting Home Page Display Performance [Q and A]

Troubleshooting Home Page Display Performance

2004/10/4 17:46
dplittle
Just popping in
Posts: 49
Since: 2004/9/15

I've just started getting a periodic problem on displaying our home page. At times, after logging in, it can take up to a minute or more to get the home page. At other times, it just pops up. Is there some way to troubleshoot what's going on?

From my SQL Server days, I would immediately think table locking but that shouldn't be the case.

Any ideas/direction/suggestions would be appreciated.

David

Re: Troubleshooting Home Page Display Performance

2004/10/4 17:54
ackbarr
Posts: 1449
Since: 2002/10/2

General purpose performance tuning tips:

1. Turn on MySQL / block debugging. This will tell you how long it takes for XOOPS to render the page, as well as the queries involved in drawing the page

2. If you are using the headlines block, perhaps the headline cache is refreshing a slow feed.

3. If you have blocks that take a long time to run, but rarely change, make your cache settings more aggresive.

Re: Troubleshooting Home Page Display Performance

2004/10/4 18:13
dplittle
Just popping in
Posts: 49
Since: 2004/9/15

Thanks ... I've turned the MySQL debug on but now I can't get it to be slow!! Isn't that always the way!

I'll watch it for a day or so and keep logging in and out trying to get it to happen again.

Right now I don't have anything cached so as soon as I see what's the bottleneck, I'll adjust.

David

Stats
Goal:	$100.00
Due Date:	Sep 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Troubleshooting Home Page Display Performance

Re: Troubleshooting Home Page Display Performance

Re: Troubleshooting Home Page Display Performance

Login

Search

Recent Posts

Re: sbadmin5 - Bootstrap 5 Theme

Re: sbadmin5 - Bootstrap 5 Theme

sbadmin5 - Bootstrap 5 Theme

Re: XoopsFaq for 2.5.10

XoopsFaq for 2.5.10

Re: activate block by default

Re: wgFilemanager released for testing and contribution

Re: wgFilemanager released for testing and contribution

Re: activate block by default

activate block by default

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}