Print Page | Close Window

Querying Large Data

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=3334
Printed Date: 20-Apr-2024 at 11:32am


Topic: Querying Large Data
Posted By: k_cire0426
Subject: Querying Large Data
Date Posted: 13-Mar-2012 at 3:18am
Hello,

What would it take to query a hundred thousand of records or more than in an N-Tier? The entity manager keeps on throwing SocketException.. 


Replies:
Posted By: sbelini
Date Posted: 13-Mar-2012 at 12:25pm
Hi,
 
Can you post the entire exception message and stack trace?
 
Thanks.

Posted By: k_cire0426
Date Posted: 13-Mar-2012 at 11:06pm
here is the deepest inner exception.

Message: An existing connection was forcibly closed by the remote host.
Stack Trace:   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

It was from CommunicationException first then SocketException which is the deepest exception.

Posted By: sbelini
Date Posted: 21-Mar-2012 at 12:07pm
Hi k_cire0426,
 
I'd consider "breaking" the query in smaller queries and executing them asynchronously.
Also, you might want to increate the query timeout. You can find more information in the http://drc.ideablade.com/xwiki/bin/view/Documentation/understand-timeouts - DevForce Resource Center .
 
Regards,
   Silvio.


Print Page | Close Window