Re: dataset question - to preserve DB resources
- From: "Chris" <cmill575@xxxxxxxxxxx>
- Date: Thu, 15 Dec 2005 20:43:29 -0500
That helped a lot.. Thanks.
My profiler trace shows 7 second queries were reduced to 1 second. Not bad.
Used a DataTable.
"Marina" <someone@xxxxxxxxxx> wrote in message
news:u27ZseZAGHA.1032@xxxxxxxxxxxxxxxxxxxxxxx
> Don't bother with the SqlDataReader. Get the data straight into the
> dataset
> (or datatable) using the SqlDataAdapter's Fill method, then do your
> processing.
>
> "Chris" <rooster575@xxxxxxxxxxx> wrote in message
> news:OVpZUYZAGHA.344@xxxxxxxxxxxxxxxxxxxxxxx
>>I have a procedure which runs a heavy SQL query, loops through a SQLreader
>>and closes the reader and connection.
>>
>> Within the loop, there is a lot of code/processing that must remain. I'd
>> like to open the DB connection, move the data to a dataSet or something
>> to
>> get the data in memory, and then immediately close the DB
>> reader/connection to free up DB resources. Then I can loop through the
>> dataSet and perform all the necessary work, without holding up the
>> database for other users.
>>
>> My question, using ASP.NET 1.1, can someone provide an example of this
>> approach?
>>
>> Thanks in advance.
>>
>
>
>
.
- References:
- dataset question - to preserve DB resources
- From: Chris
- Re: dataset question - to preserve DB resources
- From: Marina
- dataset question - to preserve DB resources
- Prev by Date: Re: Wierdness with "Imports" statement
- Next by Date: Re: best technique for connection strings in web.config in ASP.NET
- Previous by thread: Re: dataset question - to preserve DB resources
- Next by thread: NO DLL in bin folder after building
- Index(es):
Relevant Pages
|
