On 06/01/2005-07:19PM, Mark Stosberg wrote:
> 
>  - I saw the hardware tip to "Separate the Transaction Log from the
>    Database". We have about 60% SELECT statements and 14% UPDATE
>    statements. Focusing more on SELECT performance seems more important
>    for us.
> 

I would think that would help SELECT If the spindle isn't busy writing
Transaction log it can be reading for your SELECTs.  

You did say you were CPU bound though.

-- 
------------------------------------------------------------
Christopher Weimann
http://www.k12usa.com
K12USA.com Cool Tools for Schools!
------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to