How to improve Software Performance when there is huge Data in SQL Server Using VB
-
Hi, My problem is that, due to large data in SQL server, my Inventry software is getting to slow while loading data from the server, is there any solution from the database side to increase the performance, or i have to change the entire code of the software, which is going to be the worst thing to do, as i have written the code in VB, I have used distributed Database Access Layer to access the data from the database.
-
Hi, My problem is that, due to large data in SQL server, my Inventry software is getting to slow while loading data from the server, is there any solution from the database side to increase the performance, or i have to change the entire code of the software, which is going to be the worst thing to do, as i have written the code in VB, I have used distributed Database Access Layer to access the data from the database.
Maybe you may to consider not displaying all the inventory at one go. Let the user choose the category/level or whatever or filter the list by inventory code or name, ie user type in 'A*' in name filter box and your system only shows the inventory with name started with 'A'.
-
Hi, My problem is that, due to large data in SQL server, my Inventry software is getting to slow while loading data from the server, is there any solution from the database side to increase the performance, or i have to change the entire code of the software, which is going to be the worst thing to do, as i have written the code in VB, I have used distributed Database Access Layer to access the data from the database.
Optimizing Application Performance Using Efficient Data Retrieval http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1a_71nw.asp[^] ...:|
-
Maybe you may to consider not displaying all the inventory at one go. Let the user choose the category/level or whatever or filter the list by inventory code or name, ie user type in 'A*' in name filter box and your system only shows the inventory with name started with 'A'.
Hi, First of all thanks for the solution, but the problem is that i am already using filters in my software for loading the data,i am using "for loop" to append new row in the datagrid, which takes lot of time, please suggest me other solution using which i can speed up my loading data process.
-
Optimizing Application Performance Using Efficient Data Retrieval http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1a_71nw.asp[^] ...:|
Hi, First of all thanks for the solution, but the problem is that i am already using filters in my software for loading the data,i am using "for loop" to append new row in the datagrid, which takes lot of time, please suggest me other solution using which i can speed up my loading data process.
-
Hi, First of all thanks for the solution, but the problem is that i am already using filters in my software for loading the data,i am using "for loop" to append new row in the datagrid, which takes lot of time, please suggest me other solution using which i can speed up my loading data process.
Sunil, You just answered your own question. (Guy goes to the doctor and says "Doctor, it hurts when I do this." Doctor says, (all together now),) "DON'T DO THAT!" The problem is not on your database side, it is on the client side, in your code. Yes, using a for loop and adding one record at a time is the SLOWEST way to fill the grid. Use databinding if at all possible. But first of all, you haven't provided enough information to really help here. Can't fix what ya can't see. Tell which version of VB, which datagrid component you are using, which type of backing store you are filling the grid from (ADO recordset, .Net datatable, datareader, whatever), and show the sql. :)