When I open DataSet in Visual Studio 2008 to design or modify it, it always take a very long time (more than five minutes) before I can continue to do my job. While I'm waiting I can't do anything on Visual Studio, moreover CPU and memory usage is growth dramatically.
I want to know, Is it has anyway to reduce this waiting time?
Hardware - Desktop CPU: Intel Q6600 Memory: 4 GB HDD: 320 GB 7200 rpm OS: Windows XP 32 bit with Service Pack 3
Have you tried this?
Go to the Options -> Windows Form Designer and set the AutoToolboxPopulate to false. It worked for some of my team members who work with DataSet.
I hope it helps.
Assuming you're working with SQL Server datasets, maybe you should try using SQL Management Studio. It may be more tailored for that sort of work.
If not, what kind of datasets are you using, and why are they so large?
You could try ASYNC to avoid blocking if you want to process something else while you are waiting. An event would fire to indicate data has been loaded.
Hope that help,
