Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Many inserts &deletes, fastest way to delete?

Many inserts &deletes, fastest way to delete?

From: <bonanos_at_yahoo.com>
Date: Sat, 17 Jul 1999 11:02:38 GMT
Message-ID: <7mpnsc$9oq$1@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 Sat Jul 17 1999 - 06:02:38 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US