Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I speed up deleting from a very dynamic table
On Thu, 7 Jan 1999 17:02:40 +1000, "Rod Stewart"
<rod.stewart_at_afp.gov.au> wrote:
>Dear friends and colleagues,
>
>I have a table that is used as a dynamic log to record various types of
>search results. The data is very dynamic, with data moving in and out at a
>very rapid rate. Our problem lies with the speed of deletion. Is there
>some way to speed the deletion, perhaps by somehow skipping / circumventing
>all the rolling back etc which we don't require?
>
>Thanks in advance,
>
>Rod J. Stewart
>
>
It may be quicker pre-allocate a set of rows to hold temporary values,
using update instead of insert to poplulate them and update to flag
them as available for reuse when finished with.
Received on Sat Jan 09 1999 - 08:38:09 CST