Tips of linking the database to form for better the performance in Visual Studio 2010
I am working on the software project of Visual Studio 2010. I am new user to this Visual Studio 2010 environment. I have connected the database to the forms created in Visual Studio 2010. But these forms are not working well according to the performance. I am not getting the performance I want to get through this form. So I need to know the tips for enhancing the performance of the forms.
Re: Tips of linking the database to form for better the performance in Visual Studio 2010
I will like to mention some of the tips for linking the database to form for better performance.
1. It will be better if you avoid the record navigation on the linked tables. The better option will be to use PageUp and PageDown movements.
2. If the form consists of only adding records then it will better if you use “DataEntry” commands for the “Records” menu.
3. Use less number of data returned queries mean try to use minimum number or fields and records that require filter on returned queries.
4. If you are linking more than one table in your query then avoid using aggregate functions.
|Tags: odbc, sql, sql 2005, tips, tricks, tweaks, visual studio 2010|
|Thread Tools||Search this Thread|
|Similar Threads for: "Tips of linking the database to form for better the performance in Visual Studio 2010"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Visual Studio 2010: features and changes compared to Visual Studio 2008||BinDs14||Guides & Tutorials||2||16-02-2011 02:49 PM|
|updating a database using a dataset in visual studio 2010||BHlophe||Software Development||2||29-09-2010 05:33 PM|
|Techniques for better Report performance in Visual Studio 2010||Marcya||Windows Software||5||02-02-2010 02:16 AM|
|Tips to improve form performance in Visual Studio 2010||Mahajabeen||Tips & Tweaks||2||31-01-2010 04:39 AM|
|Tips for installing image library in visual studio 2010||Orion lella||Tips & Tweaks||3||24-01-2010 05:58 AM|