WCF OData Service-Timeout expired issue from mysql view

See more:

C#

WCF

MySQL

C#4.0

I have created wcf OpenDataServices with mysql DB. I am getting data from tables in a quick flash. But when I tried to get data from a view, It is throwing timeout exception. When tried directly in db data is getting very quickly.

I tried by setting the following in web.config.

<system.serviceModel>
    <bindings>
      <netTcpBinding>
        <binding name="NetHttpBinding" maxBufferPoolSize="2147483647"  closeTimeout="00:01:00"
                 openTimeout="00:01:00"  maxConnections="10"
                 receiveTimeout="00:10:00"
                 sendTimeout="00:10:00"
          maxBufferSize="524288" maxReceivedMessageSize="2147483647" />
      </netTcpBinding>
    </bindings>
    <services>
      <service name="MyService">
        <endpoint address="http://localhost:59825" binding="netTcpBinding"
          bindingConfiguration="NetHttpBinding" name="HttpBinding" />
      </service>
    </services>
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
  </system.serviceModel>

still timeout exception.

Edit1:

When I tried with a table, data is getting. I created a view for that table as select * from same table and tried with that view its throwing timeout exception.This issue is not there when using views of tables with less data.

Please help.

Thanks,
Jaison.