tags:

views:

29

answers:

1
Q: 

Visual Studio Database Edition memory problems and auto recompile

Currently storing database of a large application with 2,000 stored procedures in Visual Studio Database Edition.

The problem I'm having is that when I try and edit a stored procedure, Visual Studio becomes unresponsive and it can take 30 seconds to type in a single keyword.

What I believe is that Visual Studio is attempting to auto recompile the project/solution. Does anyone know of a workaround, can this be switched off?

Has anyone experienced the same issue?

+1  A: 

I would take a look @ this post, which talks about a known issue with the *.dbml file and that the suppression of warnings doesn't always aid in the problem. The original poster does post a workaround.

Ben.Vineyard  2010-02-25 21:49:18
Thanks BenIt kinds of looks at the symptom of the problem with the suppression of warnings. But it still appears that VSTS attempts to build the application on the fly.Would be nice to switch it off altogether. I'm still testing to see if it resolves the problem entirely.
Simon  2010-02-26 11:07:23
No problem. Please follow-up to let me know if that works for you.
Ben.Vineyard  2010-02-27 00:09:55
I'll give you kudos for what it's worth - would love to be able a final solution for this. Will be interesting to see if this is somthing that happens on VS 2010.
Simon  2010-02-27 16:36:41

related questions

What is the best way to do unit testing for ASP.NET 2.0 web pages?
TestDriven.NET is not running my SetUp methods for MbUnit
Automated release script and Visual Studio Setup projects
Setup Visual Studio 2005 to print line numbers
What is the best way to deploy a VB.NET application?
How do you pack a visual studio c++ project for release?
How to set up unit testing for Visual Studio C++
How can I create Debian install packages in Windows for a Visual Studio project?
Plugin for Visual Studio to Mimic Eclipse's "Open Type" or "Open Resource" Keyboard Access
How to generate getters and setters in Visual Studio?
Do you have any recommended add-ons/plugins for Microsoft Visual Studio?
What is keyboard shortcut to view all open documents in Visual Studio 2008
Visual Studio 2008 debugger already attached work-around
Add Custom Tag to Visual Studio Validation
ASP.NET MVC Without Visual Studio
Are Multiple DataContext classes ever appropriate?
Folders or Projects in a Visual Studio Solution?
What's a good book for learning ASP?
Integrating Visual Studio Test Project with Cruise Control
.Net XML comment into API Documentation
Visual Studio Setup Project - Per User Registry Settings
.NET Testing Framework Advice
Automatically update version number
Build for Windows NT 4.0 using Visual Studio 2005?
ASP.NET, Visual Studio and Subversion - how to integrate?