[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.inetserver.asp.db

michael kors factory outlet dtxa

Katadedajab

12/28/2013 4:48:00 PM

<a href=http://panooza.lv/><... vuitton outlet store</b></a>Thanks and then for that,element does be of assistance an all in one parcel to learn more about make an appointment with a comment on the basis of going to be the author and element also looks is fantastic.<a href=http://www.isawaprotest.com/fashionablemk.html><b&... kors bags outlet</b></a>All all around the all are going to be the your online business is the reason that a multi function good thing,but take heart element depends all over the how<a href=http://panooza.lv/><... vuitton outlet online</b></a>I not only can they a good choice away grab your rss rss feed as I can never ever find your email subscription hyperlink well e-newsletter goods and services Do all your family have any? Kindly permit my hand understand that is why that I may subscribe. Thanks.<a href=http://www.isawaprotest.com/fashionablemk.html><b&... kors purses</b></a>Having been learning, teaching and making use of their English as have the desired effect language and then for upwards of 10 a long time I am quite confident that I am an all in one using the English user. I am quite interested considering task. Please i can know about whether or not your family think I am qualified, please send my hand an all in one message. I\'d like to learn more about learn a lot more about going to be the task and your website.that/is the fact/would be the fact/is the fact that/is that often/is the reason that/tends to be that/is usually that/is because/is that/has to be that/will be the/usually/may be the/could be the/is always/is this :/often/is this} a multi function the most important reputation on the online store and get it fast.100% customer satisfaction and free shipping.Welcome to learn more about make for the investment in this posting at all of our outlet in your store available on the web best information enchanting my hand.<a href=http://panooza.lv/><... vuitton outlet online</b></a>
1 Answer

Andrew Brook

12/10/2007 11:58:00 AM

0

Hi Debasish,

I think this still matches my earlier comment, I think even though your call
to ExecuteReader returns almost immediately, the data is not all available.
I think it's like when you execute a query in the query analyser, some rows
appear quite quickly (depending on the query) but it can take some time
before all the rows are returned.

As a further test, take the DOM out of the equation, try executing the
reader and then interating of the rows that are returned. If i'm right then
it should still take in the region of 30 mins to complete.

Code would be something like:

XmlReader reader = sqlXMLReader.ExecuteReader(Query);
int count = 0;
while (reader.read())
{
count ++;
}

thanks,
Andrew

"Debasish Pramanik" <Debasish Pramanik@discussions.microsoft.com> wrote in
message news:207B5E5C-0D2B-4DBC-B895-97EB25E43758@microsoft.com...
> Hi Andrew:
>
> Thanks for quick response.
>
> This is the way I validated.
>
> Step 1: I executed the query with DOM loading. This took almost 30
> minutes.
> I did this twice and result were same.
>
> Step 2: I then executed only the query without loading the XML. It just
> took
> 6 seconds on an average for 10 iteration.
>
> This was the basis of my findings.
>
> Let me just dump the code
>
> String Query = "Select .... FOR XML EXPLICT";
>
> XmlReader reader = sqlXMLReader.ExecuteReader(Query); <== this takes 6
> seconds
> XmlDocument xmlDoc = new XmlDocument();
> xmlDoc.Load(xmlReader); <==== This takes 30 minutes
>
>
>
> "Andrew Brook" wrote:
>
>> Hiya,
>>
>> When you say it took 6 seconds for the query to complete, are you sure
>> it's
>> actually completed? Even though the reader starts returning data, i'm
>> fairly
>> sure this does not mean all the data for the query has been full
>> prepared.
>> If i'm not talking garbage, it could mean that your query is actually
>> taking
>> 30 minutes to fully complete, in which case, optimizing your query may be
>> better then changing the way you load your xml
>>
>> Andrew
>>
>> "Debasish Pramanik" <Debasish Pramanik@discussions.microsoft.com> wrote
>> in
>> message news:994F1554-46DF-47C5-AE32-839334B002F2@microsoft.com...
>> > We do a FOR XML query using SQLXMLReader.ExecuteXMLReader() method. The
>> > results is obtained in a XMLReader. We then load XMlDocument using
>> > XmlReader
>> > as we have to process the XML.
>> >
>> > When we try to fire a query which returns huge data, the query
>> > executed
>> > by
>> > database is 6 seconds but to load the XML it takes 30 minutes. It could
>> > be
>> > 30-50 MB xml.
>> >
>> > Is there any better way to load the XML.
>>
>>
>>