Re: How to tune database with lots of very light queries

From: Keith Moore <>
Date: Tue, 29 Apr 2008 11:13:17 -0500
Message-ID: <0e5201c8aa13$fb72e290$6701a8c0@spresso>

Are bind variables being used? I'd make sure parsing is kept to a minimum since I'd guess that is where most of your CPU load is. Keith

  We have some databases with load profile like lots of light query (mostly pk based), each execution cost only 3-6 buffer_gets and no complex join etc.   But due to excessive executions (10K+ query per second), load is also driving pretty high.

  Anyone has experience tune such kind of application/database? From single SQL point of view, they are already perfect.

Received on Tue Apr 29 2008 - 11:13:17 CDT

Original text of this message