I once had a similar problem with a few users monopolizing a database
server with looong running querys. The OS was NetWare with Oracle on a
2x500MhZ PII, 1Gb RAM and about 4-6Gb database.
When optimizing performance on this system I finally found that if I
split the main server into two different servers, one main server and
one slave server with a replica of the main server, the overall
perfomance was optimal for all users.
All input to the database was on the main server and the heavy querys
performed on the slave, since they didn't insert any new data to the
database.
This is quite easy to implement in NetWare, haven't got a clue about if
it'll work in Windoze.
Dunno if this might help you with any ideas...
/Johan
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
