Speed of boards
- Thread starter Tom
- Start date
Gumbo
It's my birthday today!
- Joined
- Dec 22, 2003
- Messages
- 2,361
/me sets alarm to get up and post shite to entertain Cask at ridiculous times of the night.
If it is a server load query thingamiebob issue, then is there any way at all that the daoccie bits could be on a seperate box as suggested earlier, or is that a technical no-no?
Seems like the easiest solution to the problem on the face of it, (should that of course be the problem).
I'm still on isdn so it's all a much of a muchness for me *shrugs*
If it is a server load query thingamiebob issue, then is there any way at all that the daoccie bits could be on a seperate box as suggested earlier, or is that a technical no-no?
Seems like the easiest solution to the problem on the face of it, (should that of course be the problem).
I'm still on isdn so it's all a much of a muchness for me *shrugs*
- Joined
- Dec 11, 1997
- Messages
- 9,077,157
Yo yo
Quite an interesting thread to read is this!
Well the issue lies in the hardware, it is nothing to do with bandwidth.
Firstly, GZIP on the server actually helps. It is NOT a cpu issue.
Currently the entire FH forums including the SQL backend run on a single dual processor p3 650mhz server using UltraWide scsi disks.
This puts the system at a serious disadvantage when it comes down to disk i/o and memory.
MySQL relies on the operating system to cache the tables (the actual data) but can cache the indexes itself etc. Apache also needs its chunk of this memory and I have had to throttle both the applications down to a level where the system does not swap - makes it even worse.
I do have another piece of hardware that I need to commission but as Ted said, my new role has taken up a large chunk of my time.
Saying that, I have made some changes to the forums to reduce the number of queries the SQL server has to do to minimize disk i/o but that will stop not help if we get a sudden influx of 500 people coming here, especially if over slow connections as that will hold open an apache process (therefore memory).
Gah, I hope it makes sense, too early on a Saturday morning to get technical!
Quite an interesting thread to read is this!
Well the issue lies in the hardware, it is nothing to do with bandwidth.
Firstly, GZIP on the server actually helps. It is NOT a cpu issue.
Currently the entire FH forums including the SQL backend run on a single dual processor p3 650mhz server using UltraWide scsi disks.
This puts the system at a serious disadvantage when it comes down to disk i/o and memory.
MySQL relies on the operating system to cache the tables (the actual data) but can cache the indexes itself etc. Apache also needs its chunk of this memory and I have had to throttle both the applications down to a level where the system does not swap - makes it even worse.
I do have another piece of hardware that I need to commission but as Ted said, my new role has taken up a large chunk of my time.
Saying that, I have made some changes to the forums to reduce the number of queries the SQL server has to do to minimize disk i/o but that will stop not help if we get a sudden influx of 500 people coming here, especially if over slow connections as that will hold open an apache process (therefore memory).
Gah, I hope it makes sense, too early on a Saturday morning to get technical!
- Joined
- Dec 11, 1997
- Messages
- 9,077,157
Jonty said:hehe
Will you be upgrading to vB3 RC4, Deebs, or just waiting for the final release?
Kind Regards
Jonty
P.S. This just popped up, hehe
The board closed message popped up as I just moved SQL.
I am more than likely gonna wait Jonty for the final release, according to the vb devs its a matter of days.....
Deadmanwalking
Fledgling Freddie
- Joined
- Dec 29, 2003
- Messages
- 812
Is the move why the number of users viewing boards etc isn't about anymore?
