Comments
Sort by recent activity
fllouw wrote:
An update: I found the reason for the performance difference. The large database had a single encrypted object (a 5-line stored procedure), and the option to decrypt encrypted objects was checked (it is checked by default). Unchecking the option to decrypt encrypted objects solved the performance issue.
Thanks,
Francois
Thanks fllouw, that also fix the performance problem in my case as well. Now the only question that remains is why option to decrypt encrypted objects causes so much overhead, but that is a question I will leave for another day.
Cheers! / comments
fllouw wrote:
An update: I found the reason for the performance difference. The large database had a single encrypted object (a 5-line stored procedure), and the option to decrypt encrypted obje...
Update:
I left the snapshot generation to run a few more hours and apparently after all these time it finally finished.
I'm not sure how many hours it took in the end or whether it really got stuck at some point in time or it was just SUPER slow.
Having said that, you replied asking me to provide the log. I have no problem in doing so but I have no idea where it is located.
If you point me to the Log file I will update the call with a copy of it. Unfortunately I can't attach also the screen shot because, as I said, the process completed after a few more hours.
Regards, / comments
Update:
I left the snapshot generation to run a few more hours and apparently after all these time it finally finished.
I'm not sure how many hours it took in the end or whether it really got stuck...
Will Do
Thanks James! / comments
Will Do
Thanks James!
Disregard this problem... I'm not sure what has happened but I can't reproduce the behavior I posted in my previous post anymore.
I thought the problem was constant but apparently it is erratic and I can no longer see the prompt missing when closing a modified projects.
Thanks! / comments
Disregard this problem... I'm not sure what has happened but I can't reproduce the behavior I posted in my previous post anymore.
I thought the problem was constant but apparently it is erratic and...