|
>DB tuning always needs advanced tricks and most of the time you need a
> Russian guy to do this :)
Database tunning is pretty simple really :
The less you access the persistent IO (hard disks) the faster it goes...
So you need 1 database server say a 1GHz,500MB RAM with minimum 2HDs but
preferably 2*mirror for tran logs and 2*mirror for data (more disks the
better obviously ) £1K-£5K ?
Then you set up your DB with data & OS on one IO channel and logs ONLY
on the other. (what ever Microsoft says Oracle is right on this...)
And this database is ONLY used for sessions (nothing else)
All the rest of your data can stay on the current DB server (or split it
over read only mirrors if required balanced by LVS of course)
Should be pretty damn fast no ? and it also means you can scale up your
web servers as much as you like without worrying about persistence.
The above applies for any decent database PostGreSQL, Oracle, DB2,
Sybase, Informix, MSSQL etc.
just my 2 pence.
--
Regards,
Malcolm Turnbull
IT Manager
Crocus.co.uk Limited
Nursery Court
London Road
Windlesham
Surrey
GU20 6LQ
01344 629661
07715 770523
http://www.crocus.co.uk/
"They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety." - Benjamin Franklin
|
