Re: What to do? Many updates and selects

When you say one line update or select, I assume you are referring to primary key access as you can still select or update one single row and result in full table scan.

I don't think you need a lot of CPUs. A Sum 480 (4 x 1200 Mhz) can handle up to 2500 healthy queries per second at full capacity. Update is more expensive both CPU and IO wise, mostly due to log writer activity. For pure updates, the same box can probably handle 1500 updates per second. - So can your log writer handle that kind of thru put if you use SAN.

But this is strickly judging from capacity. You can still get into performance problems if you have hot blocks or bad tuned DB. Received on Thu Jun 02 2005 - 16:30:17 CDT