Re: Insert performance Tuning

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: 7 Jun 2004 23:42:19 -0700
Message-ID: <1deef760.0406072242.1c321565@posting.google.com>

"Fusheng Wang" <wangfsh_at_cs.ucla.edu> wrote in message news:<ca3799$9jp$1_at_daisy.noc.ucla.edu>...
> HI,
>
> I have a database with intensive updates, but the updates tend to be slow.
>
> Any suggestions on database tuning on better insertion performance?
>
> Thanks a lot!
>
> Frank

I suggest beginning with the goal of minimizing the number of database calls that your application uses to perform the insertion operations. For example, use array-processing features so that your application manipulates more than one row for every EXEC call that will show up in an application's SQL trace data. The fewer calls that are required to get a given job done, the better your application will perform, and the better it will scale under increased use.

Cary Received on Tue Jun 08 2004 - 01:42:19 CDT