Re: Canceling a Query
| From: | Johan Lundqvist | Date: | Fri, 18 May 2001 13:38:49 +0000 |
| Subject: | Re: Canceling a Query | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-7723@lists.php.net to get a copy of this message | ||
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