Select Large Data From WCF Services

Question

0.00/5 (No votes)

See more:

Hi friends,
How can i improve Wcf services performance..

if i retrieve 1000 or more records from sql database to Wcf services it's take 10 mins time to load the data...how can i solve this issue..?

I used below settings in my web.config

<basicHttpBinding>
        <binding name="basicHttpBindingSettings" closeTimeout="10:00:00"
          openTimeout="10:00:00" receiveTimeout="10:00:00" sendTimeout="10:00:00"
          bypassProxyOnLocal="false" maxBufferPoolSize="2147483647" maxBufferSize="2147483647"
          maxReceivedMessageSize="2147483647" textEncoding="utf-8" transferMode="Buffered"
          useDefaultWebProxy="true" messageEncoding="Text">
          <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647"
            maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />
        </binding>
      </basicHttpBinding>

Please help me

thanks in advance
Ram

Posted 27-Jun-14 19:01pm

.net333

Updated 27-Jun-14 19:05pm

v3

Add a Solution

Comments

DamithSL 28-Jun-14 1:12am

You need to optimize your sql query

.net333 28-Jun-14 1:27am

thanx Damith...may be my query optimized..

here is my query and executing fast in my sql server

select distinct(Name) as CategoryName from Lookup l,RestaurantAppInfo R,RestaurantMenu M where
R.CuisineTypeId=@Cuisinetype and R.CuisineTypeId=L.Id and R.AppId=M.AppId
and M.EntityType='Category' and M.Active=1

1 solution

Add a Solution

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

abhi_49 · Answer 1 · 2014-06-30T23:37:00

Solution 1

Hi,

May be below link will help you.

http://stackoverflow.com/questions/264366/performance-tuning-wcf-service[^]

Posted 30-Jun-14 23:37pm

abhi_49

Comments

.net333 9-Sep-14 2:54am

thank you abhi..i'll go through with the above link

Select Large Data From WCF Services

1 solution

Solution 1

Add your solution here

Preview 0

Select Large Data From WCF Services

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us