Dataset

  • Thread starter Thread starter Krishna Kumar
  • Start date Start date
K

Krishna Kumar

Hi,

I am searching for file name in database.
From SQL Server Stored Procedure i get data into DataAdapter. From
DataAdapter i fill into dataset, and i show the records in datagrid.

From 2 lakh record, my stored procedure checks for validation and give me 10
records. It takes much time.

So i am planning to fetch all records into dataset when application
starts(in a seperate thread). This dataset remains until i close my
application. For searching i can going to use filter.

So, my question is... When i store 2 lakh record in dataset, Will it reduce
the performance? Where does this dataset temporarily store 2 lakh record? Is
it advisable to fetch all records in dataset in a separate thread?

Thanking you in advance

Regards
S. Krishna Kumar
 
Krishna,

Will you be so kind not to multipost, when you use Outlook Express you are
able to crosspost, than we can answer you once and others can see the
answers.

Thanks,

Cor
 
Hi,

First, you can try to tune your indexes and sp and see if that improves the
performance of the sp.

Next, After fetching the data at the beginning of the application, instead
of storing the data in memory, you can save in a disc file. Whenever you need
to search, load this file into the dataset and search.
 
Hi Saravanan,

Thanks for your time. What kind of disc file?. Is it XML file or any other
type?
I am new to dotnet. If my question is silly, i am sorry.

Thanking you in advance
Regards
S. Krishna Kumar
 
Back
Top