I am having a very large website which have around 400000 nodes of story content type. And these nodes have around 2000000 revisions. How can I delete all the revisions except the current revision so i can reduce the size of my database.
I have tried node node revison delete module with no success. Page is getting time out.