Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: WCF WPF MVVM
Hi all,
 
I am getting this exception when trying to get data from the database.
 
The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.
 
But we can solve this issue by increasing the value of MaxReceivedMessageSize in app.config.
 
My Question is if we have millions of data then what is the solution for this issue.
 

Thanks
Kishore
Posted 8-May-13 23:08pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Break it down into chunks. It is only the individual message size limit that is being reached so, if for example you are transmitting a collection of data, send it in chunks rather than all at once.
  Permalink  
Comments
KishoreUHG at 9-May-13 6:49am
   
Without making chuncks can we achieve this..
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Yes, I agree with Solution 1 as Chunking would be the most preferrable solution rather than increasing the buffer (quota) limits of a Service because once quota is set then always that much big buffer would be allocated unnecessary even for small amount of data.
 
Chunking can be implemented, for example, by getting chunk of data as per the Page number selected in a Grid (Paging should be enabled).
 

I hope it was clear but if you get any queries please let me know.
  Permalink  
Comments
KishoreUHG at 9-May-13 6:49am
   
Without making chuncks can we achieve this..
Mohammed Hameed at 9-May-13 8:45am
   
I think Almost impossible without chunks.
 
Anyhow let me do some R&D and will update you if I find any good alternative.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 285
1 DamithSL 265
2 CPallini 195
3 Maciej Los 175
4 George Jonsson 170
0 OriginalGriff 5,415
1 DamithSL 4,422
2 Maciej Los 3,820
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,911


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 9 May 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100