Re: Many inserts &deletes, fastest way to delete?

Hi.

 My idea is about the same - avoid DELETE online.

1. Make your TIMESTAMP field nullable.
2. Create an index on TIMESTAMP field.
3. Create a view to retrieve last 5 minutes data ( ensure the index is used ).
4. Start od\ff-line process once a while to delete old data.

 In any case - such tables prone to fragmentation.  TRUNCATE them from time to time.

 Good luck. Michael.

In article <7mpnsc$9oq$1_at_nnrp1.deja.com>,   bonanos_at_yahoo.com wrote:
> Hail World Programmers.
>
> I have a group of tables that I insert many records into.
> I also delete all records that are more than five minutes old.
> Currently, through PL/SQL before I do the inserts, I call a procedure
> that delete all aged records, if there have been many inerts, the
> deletes take a few seconds, which causes a delay in my web
application.
>
> Is there a way to speed this up, If I leave the records in the tables,
> and do a check every hour etc, will this be faster, should I
investigate
> temp tables in 8i.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 15:42:01 CDT