Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Many inserts &deletes, fastest way to delete?
Hi,
Perhaps it is better to use some sort of a circular buffer. You can overwrite the oldest record with new values if it is more than 5 minutes old. This should be more efficient than bulk deletes and subsequent insertions.
Andries.
If it doesn't fit, use a bigger hammer Received on Tue Jul 20 1999 - 14:04:41 CDT