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

Hi,

did you check your redo-logs? Maybe they're too small and database runs into checkpoint not complete.
A job, which deletes your records every hour, would not affect your queries, so the selects should be faster without doing a delete.

The idea of Daemond is also a good idea.

Bye
Uli

<bonanos_at_yahoo.com> schrieb in im Newsbeitrag: 7mpnsc$9oq$1_at_nnrp1.deja.com...
> 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.
Received on Sun Jul 18 1999 - 06:23:36 CDT