Site Slow

[htc]

Hi there,

I have had complaints that the forum I run is slow. It will load, but when you go to a new topic and post, it puts up the title header and then there is a 30-40 sec delay between it displaying the box to type in. It frustrates me as well. I have had a new member leave because of the slowness which is disappointing.

I would like to know how to fix it - how do I find out if it is the skin or the server it is on or somehow change settings to make it quicker.

It is a new forum - 15 members thus far 5mb database size. I have added no mods, using the standard IPB skin, nothing more. The website that is also on the site is fine and had no complaints about this.

Thanks
:)

[sPiDeRz]

15 members and a database size of 5MB :S
i have just over 100 members and my database size is 9.45MB

Anyways the delay in loading could be a number of reasons, namely your hosting provider.
Could also depend on where u host your site and where you or your members are.

If you use cPanel as your hosting admin panel check the server status and make sure there is no red dots.
You might also wanna submit a ticket to the company and ask about latency issues on the server your site is hosted on.

[surendras]

It is a new forum - 15 members thus far 5mb database size. I have added no mods, using the standard IPB skin, nothing more.

I don't think IPB is an issue for that small size of board.
I am running IPB board with thousands of members and it's working better than many other scripts.

I suspect the reason could be your 'hosting provider'. Make a complaint to them.
May be they are overloading the server with too many hosting accounts.

[vivianeg]

if html site working normal.
slow : is the sql server you'r host is running. best is to make a ticket by you'r hosting whit this issue.

ipb can not help whit you this.

;)

[htc]

I have sent a message to the host who said he is looking into it. I checked the stats and the server says 36% - not sure what that means if it is 36% full or what. It runs really slow at certain times and then fast at others, sometimes pausing for up to 1 min or longer before downloading a page fully.

All of the indicators on the server status is ok and green

[vivianeg]

its the server, believe me.

do you optimize you'r sql ? acp / admin / SQL Management / SQL Toolbox
select all and optimize .

also you can go to PHPMyAdmin page select the sql database and look bellow for overhead tables.

this i do every week. also made a backup before doing this.

;)

[AndyF]

Moving topic to "Server Management, Resources, Optimization"

[htc]

How do i back up the database??

Thanks

[AndyF]

How do i back up the database??

Thanks

The easy way if you have Cpanel is to click "backups" then click on the database name :)

[Bobsuch]

How do i back up the database??

Thanks

If you have access to ssh:
mysqldump --opt -u username -p dbname > /home/path/backup.sql

[htc]

Can I ask how long this optimise takes - 5 mins - 5 hours and can people use the board while i do this?

I would like others opinions on the speed of the forum.

It is at www.healingthroughcreativity.org/forum

It goes slow sometimes (and it is painfully slow) and then other times quick?

Thanks

[Bobsuch]

Are you on a shared host? If so, complain to your webhosting provider of the slowness, as it could be other websites on your server eating too much resources.

[bfarber]

The optimize queries will take different amounts of time depending on how much data is in each table. There's no way to tell you how long they would take.

Running an optimize table query on a posts table with 4 million posts is likely to take an hour or more.