How to make my application faster
Hello,
I have a problem with my application is a little bit slow. It takes 1-2 sec to change panels. Below i describe how it works.
Description:
Main form with splitContainer.
SpliContainer1 has a treeview.
SplitContainer2 has PanelCustomer, PanelOrders.
PanelCustomer retrieves data filtered by CustomerID from SQL Server and has insert/edit/delete actions.
PanelOrders has two sections. At first it gets all orders for the selected customer (with their details) and it shows in TabControl the products for the particular order, some history and the warehouses of the products.
It keeps opening and close connections to SQL Server.
Any suggestions how to make it faster? ( i know it a general description)
Thank you in advance.
DealyPosted Aug 30, 2009, 10:33 AM
The problem though appears when i retrieve data from 3 diffrent tables which are related. I call 3 different stored procedures with 3 different connections. Do you think it would be better if I had one connection that call all the 3 stored procedures?
Kirtan PatelPosted Aug 28, 2009, 8:58 AM
Filter the Data From Dataset .
Like
When you run application . Your Dataset should be filled with data . after that dont interact with database if you just want to filter data you can fillter data from that filled dataset.
interact with database only when you want to Insert/Update/ Delete the data
DealyPosted Aug 28, 2009, 8:54 AM
I use dataset for showing data (in order to work with dataNavigator). For inserting/editing i just pass the fields as parameters in a Stored Procedure.
Kirtan PatelPosted Aug 28, 2009, 7:36 AM
Interact with database only when you insert / Update the Record :)