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

From: Damond Walker <dwalker_at_iximd.com>
Date: Sat, 17 Jul 1999 16:58:06 GMT
Message-ID: <yC2k3.158$w36.25162@typhoon1.gnilink.net>

bonanos_at_yahoo.com wrote in message <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.
>

Would it be possible to mark the records as deleted? Add a one byte field called "DELETED" and set this value to 'Y'. Then use some scheduled event to purge the records when database usage isn't high. I'll bet you will have to modify some queries to support this though.

Damo Received on Sat Jul 17 1999 - 11:58:06 CDT