Re: INSERT performance on large table.

"John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote:

>The database has no trouble with tables with multi-million records. As long
>as its properly indexed, performance will be pretty good.
>Whether or not to stage the 4000 daily records depends on what they are for.
>Are the recording transactions that occur and are kept as a log of activity?
>Or are they new orders that need to be processed that night? If the latter,
>then a staging area is a good idea to avoid slowing down the nightly process
>by accessing a large table.

The orders are processed realtime. Is partitioning a good idea?
>
Received on Tue May 15 2001 - 06:25:57 CDT