Dataset

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
Sat Mar 12 04:55:09 CST 2005

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

SaravananKV
Mon Mar 14 04:43:08 CST 2005

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" wrote:

> 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
Mon Mar 14 22:26:24 CST 2005

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

"Saravanan K V" <SaravananKV@discussions.microsoft.com> wrote in message
news:B4BFCEDD-C3FF-4999-B63F-8023260B00A6@microsoft.com...
> 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" wrote:
>
> > 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
> >
> >
> >