Dataset

[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

 

[Cor Ligthert]

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

 

[Guest]

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.

 

[Krishna Kumar]

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