MYSQL InnoDB fast delete?

I have an InnoDB table that continually refreshes with a new set of data.

So, I do a delete from table (everything) and then insert the new set of data.

However the table can never be Without a data set, so I do the above in a transaction.

Everything is wonderful functionally, but the deletes is getting dangerously slow.

Does anyone know of a non-DDL way of speeding up开发者_Python百科 deletes ?

I wonder if creating a second table "nextdataset" and then renaming it would work, I've never tried this. http://dev.mysql.com/doc/refman/5.0/en/rename-table.html

Can you say something more about the table? (for example contraints, foreign keys, etc.?)

Without any information I would suggest

TRUNCATE

Here's documentation: Mysql-Truncate

Use TRUNCATE TABLE (MySQL manual)

run the command \G SHOW INNODB STATUS in your mysql monitor when deleting or truncate process operation. MyIsam Table is much faster than InnoDB, but no rollBack is possible..