How to improve performance for Import process in Azure

giang le asked on November 19, 2015 10:34

Hi all,

As the subject, I have a website run on Azure and when I import a package into this website, it take many time (about 1-2 hour, sometime event log show data connection time out error and site is hang up). I can not detect the root cause of this problem. I try to check my internet connection speed however I think it it not root cause. So that can you let me know the cause of this problem or let me know any solution to improve it.


Recent Answers

Timothy Fenton answered on November 19, 2015 11:51

Hello Giang, are you referring to importing through the Sites module? If so, I would recommend moving the file over to the server via FTP if possible ( you would move it to '~\CMSSiteUtils\Import\' ), and then unzipping the file into a folder with the exact same name as the zip, for example:

I have the following file:

So I will extract this zip file to a directory with the same name, the folder will be called: export_20151116_1104

You know you have extracted it correctly if directly under that folder you see a Data folder.

The reason I recommend this is two reasons, first moving it to the server makes it so you don't have to upload it and wait for .NET to upload it correctly ( .NET is not very good at sending large files usually ). And Second, moving it into a folder instead of a ZIP file will cut down drastically on time since one of the first things the import usually has to do is unzip and this process can take a while if you don't already have it done. Try these suggestions and see how long it takes, it should be quite a bit shorter.

0 votesVote for this answer Mark as a Correct answer

giang le answered on November 20, 2015 04:15

Thanks Timothy for quick answer!

I try your solution, however I think this solution just improve Step 1-3 of import progress but my issue occurred in Step 4. Sorry, my question is not clear. So do you have any idea to improve process speed in Step 4? This issue just occurred on Azure, in my local server this progress is very quick.

One more, after each import progress, I viewed event log, there are many error with "MacroResolver". Is this a cause of this issue?

Example for a "MacroResolver" error

Security check of the expression 'Rule("!CurrentUser.CheckPrivilegeLevel(UserPrivilegeLevelEnum.GlobalAdmin);", "does not have!0select operationtext0GlobalAdminGlobalAdmin0select leveltext1")|(user)administrator|(hash)599e5acbf6295a8c435db8f478d1561535ee53fa54c40a677dc7460da198697e' didn't pass. The expression was signed by user 'administrator'. Remove the signature and re-save the expression by a user with proper permissions.
0 votesVote for this answer Mark as a Correct answer

giang le answered on November 25, 2015 04:59

Anybody help me pls!

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.