ay to go as well... I
might give that a shot.
-- Nathan
> -Original Message-
> From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 4:01 PM
> To: Neulinger, Nathan R.
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: suggestions for implemen
; Subject: AW: suggestions for implementing heavily used log tables with
> nightly delete
>
>
> > I basically have a situation where 300,000+ rows are being
> inserted into a
> > log table daily, and also needing to be cleared out based on a
> > tstamp. What
> > I
On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote:
>
> Got any suggestions on how these could be implemented? particular
> table types/setups/etc?
>
> I basically have a situation where 300,000+ rows are being inserted
> into a log table daily, and also needing to be cleared ou
> I basically have a situation where 300,000+ rows are being inserted into a
> log table daily, and also needing to be cleared out based on a
> tstamp. What
> I've found is that the inserts work fantastic, but when I got to do the
> delete, even if it doesn't do anything, it sits there and blocks
Got any suggestions on how these could be implemented? particular table
types/setups/etc?
I basically have a situation where 300,000+ rows are being inserted into a
log table daily, and also needing to be cleared out based on a tstamp. What
I've found is that the inserts work fantastic, but when
