This project has moved. For the latest updates, please go here.
1
Vote

Restoring backup takes foever, now 1hr+ and still going!!

description

I have just used your tool to create a backup of over 10 tables and over 200k rows in total.
backing up takes about 7 seconds, but restoring the same backup takes forever.

Now i do have some tables with triggers & indexes, could this be the problem?
How can i work around this problem?

comments

adriancs wrote Mar 24 at 2:54 PM

Can you share some sample triggers & indexes which similar to your database.

I will first try to simulate the database conditions as yours and try to repeat your problem.

If I am able to repeat the error, I might be able to find the solution.