Deleting records

[Gizmo]

Hello,

I hope anyone can help me with this.
We test a program with a table with 1 million records. But now and then we have to delete all the records and start with new tests.

But it takes a very long time to delete all the records.
Does anyone know how we would be able to do this in a short time?

Thanks,

Gizmo.

 

[cecsno]

You can do a probkup to disk prior to starting the test, and do a prorest after the test.

 

[Norman Biggar]

If you're sure you've got a validated backup, you could try running with no integrity - use the "-i" session parameter.

Alternatively, check whether you have delete triggers on the records and consider disabling the triggers.

 

[tdi]

I've done the same

I had exactly the same situation, a table with 1 million sales, but when wanted to restart, it take to long to erase, so i went to Data Administrator Tool, and deleted the table and reload the table's definition, it's faster anyway... (It was a testing table)