Why is Add New Item in SSDT so slow?

Question

I'm using SSDT 10.3.20225.0 running in Visual Studio 2010, SP1.  When I go to add a new item (either through the Solution Explorer or SQL Server Object Explorer (using the power tools) the dialog box for add new item takes many seconds to appear.  This occurs only when the database project is what I'm adding to.  When I'm in another class library or web project the add new item dialog is quite snappy in comparison.

What is going on here?  It loads the same list every time so I would think that this would be a very fast window to bring up.  Is there some level of caching that could help with this? 

Perhaps it's just my machine, but I've gotten to the point where I'm doing copy of other existing files and cleaning them out rather than using the new item dialog because that's a heck of a lot faster.

---

- Mike Wood http://mvwood.com | http://nplus1.org | http://cinnug.org

Answer 1

Hi Mike -

I've opened a bug (977868) on our end to run this under the profiler & see what we can come up with.

Thanks,

Mike Kaufman

Microsoft Corp. 

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Thanks!  Also, I've noticed that access the properties on any file in the SSDT is exceeding slow as well compared to files in other project types.  You may want to check that as well.  For example, if I select a file in the solution explorer and left click -> select properties (or press F4) it flips to the properties window but then is very slow to populate it with the correct information for that file.  On other non SSDT projects this operation takes very little, if no appearent time.  This has caused me to mistakenly set properties on files as I thought it had refreshed to show the file's information, but turns out it was still showing the information from the previous file.

---

- Mike Wood http://mvwood.com | http://cinnug.org | http://windowsazurebootcamp.com

Answer 3

Thanks Mike.  I've opened another bug for us to profile the property window population as well.

Thanks,

Mike Kaufman

Microsoft Corp.

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

FYI that the recent update of SSDT should have this fixed.

---

This posting is provided "AS IS" with no warranties, and confers no rights