DevForce Community Forum : Querying Large Data http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Querying Large Data Sat, 11 Apr 2026 05:50:32 -700 Wed, 21 Mar 2012 12:07:02 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3334 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Querying Large Data : Hi k_cire0426,I'd consider... http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=13050#13050 Author: sbelini
Subject: 3334
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 DevForce Resource Center.
 
Regards,
   Silvio.
]]> Wed, 21 Mar 2012 12:07:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=13050#13050 Querying Large Data : here is the deepest inner exception.Message:An... http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=12979#12979 Author: k_cire0426
Subject: 3334
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.


]]> Tue, 13 Mar 2012 23:06:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=12979#12979 Querying Large Data : Hi,Can you post the entire... http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=12974#12974 Author: sbelini
Subject: 3334
Posted: 13-Mar-2012 at 12:25pm

Hi,
 
Can you post the entire exception message and stack trace?
 
Thanks.
]]> Tue, 13 Mar 2012 12:25:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=12974#12974 Querying Large Data : Hello, What would it take to query... http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=12965#12965 Author: k_cire0426
Subject: 3334
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.. 
]]> Tue, 13 Mar 2012 03:18:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3334&PID=12965#12965