Performance problem with deleteing large number of rows from a table

Giganews Newsgroups
Subject: Performance problem with deleteing large number of rows from a table
Posted by:  faisal.manso‚Ķ@gmail.com (faisal.manso…@gmail.com)
Date: 10 Aug 2006

I am having performance problem with my application while deleting
large number of rows from a table.

How can I imporve performance of deleting large number of rows > 500000
from a table with the following constraints.

1. Table does not have indexes, PK etc (This should help deletion --
Hope I am right)

2. Multiple clients can issue delete quries for deleting subset of
table data. (For example table might contain 50,0000 rows for product
A. If a user loading fresh data for product A he will first delete the
previous data of product A and then upload the new data, similarly
another user might be working with product B etc and they might be
running the delete query simulataneouly)

3. User might not have DDL rights so creating a new table and deleting
the old one is not possible.

Currently we are using delete quries which is taking a lot of time.

Faisal

Replies