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
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