Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 30-01-2010
Member
 
Join Date: Nov 2009
Posts: 948
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.
Reply With Quote
  #2  
Old 30-01-2010
Member
 
Join Date: Apr 2008
Posts: 392
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.
Reply With Quote
Reply

  TechArena Community > Software > Tips & Tweaks
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 10:50 AM.