I transfer the backup of the DB of the application to my server and save it.
This is a backup function for users of my application.
This function saves "select" on file. Then transfer the file to the server.
And the restore downloads files from the server and "inserts" one record at a time.
But the restore is very slow. It looks like the screen freezes during restore.
I play an icon (loading) with a sprite, but playback also stops.
It will return to normal after restore, but this will think that the user freezed.
Is there a way to display the progress in this way?
Or is there a better way?
For example, if I backup and restore DB files as files, is it fast?