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
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