Sending DataSet from SQL to VB.NET Win App

awdigrigoli

Member
Joined
Mar 30, 2005
Messages
12
Programming Experience
5-10
I have a SQL table that contains around 250,000 records. My application needs to get this data quickly without hesitation from the users perspective. I have set up a few indexes and I still need to set the tables Primary Key. The .NET calls a stored procedure that returns the data in a DataSet. Currently the result takes between 2-3 minutes to display in SQL's Query Anayzer and timesout in the Win App.

What would be the quickest way to get the data from SQL to my Win App? Will setting a Primary Key be all I require or should I use a different method alltogether?

Thank you,
Anthony
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
Well I can't see that you'll be able to speed it up all that much programatically.
I'd recomend;
1.Upgrading your SQL server
2.Running a maintenance wizard on the DB
3.Splitting the table
4.Deleting any unneeded recourds
5.Check your normalization

TPM
 

awdigrigoli

Member
Joined
Mar 30, 2005
Messages
12
Programming Experience
5-10
Is there a way to store the last record requested from a SQL table so I could uas a stored procedure to get the records incrementally and display each in my Win App everytime the procedure is called. I know that will cause alot of round trips, but to the user the time loading each window will seem effortless.

Thanks, Anthony
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
Well you could select into a temp table, but if you have more than a couple of clients that's going to get messy very quickly.
 
Top Bottom