Tips to improve form performance in Visual Studio 2010

[Mahajabeen]

I am learning to use the Visual Studio 2010. That means I am a new bee to the working environment of Visual Studio 2010. Currently I am working on a low level project such as inventory system or the library system. I have designed the forms of this project best as per my knowledge but the overall performance of the form is very low. So I need the tips for improving the performance of form in Visual Studio 2010. I will be waiting for the related replies.

[ChrisUlrich]

Here are some of the tips for improving the form performance in Visual Studio 2010.
1. If the work of the form is completed then it will be better to close the unused forms since every form which is opened consumes the memory space and affects the overall performance of the project.
2. If you application use some form again and again in a short interval of time then it will better if you do not unload the form, instead of that you can hide the form. So that it can be seen next time at the faster rate.
3. If your form basically used for adding new records and the record source of the form contains a huge amount of records then it will be better to set the DataEntry property of the form to “Yes”

[XDRoX]

Some more tips related to improve the performance of the form in Visual Studio 2010.
1. If it is not necessary then do not add the sorting function to the form data. Because the sorting of data takes time and this will reduce the overall performance of the project.
2. Use the queries in such a way that it can reduce the number of fields returned this will help the form to load faster.
3. Index those field of the subform which are used for linking the main form. It will be better if you index all the fields in the subform that are going to use criteria.