New Posts New Posts RSS Feed: Querying Large Data
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Querying Large Data
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
k_cire0426 View Drop Down
Newbie
Newbie
Avatar

Joined: 21-Jan-2012
Posts: 12 		Post Options Post Options   Quote k_cire0426 Quote  Post ReplyReply Direct Link To This Post Topic: Querying Large Data
    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.. 
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post Posted: 13-Mar-2012 at 12:25pm
Hi,
 
Can you post the entire exception message and stack trace?
 
Thanks.
Back to Top
k_cire0426 View Drop Down
Newbie
Newbie
Avatar

Joined: 21-Jan-2012
Posts: 12 		Post Options Post Options   Quote k_cire0426 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down