Hello.
I have a Silverlight application that performs queries to the database SQL Server. In a table I have 1 million entries, as follows:
starts with the letter A: 130.000
starts with the letter B: 16.000
starts with the letter C: 70.000
When I run the query the first time, in case the letter A, the return is faster, the later will become increasingly slow. The impression I have is that the buffer will accumulate data.
Does anyone have an idea how to solve this?
To work with large amounts of data and simultaneous queries, how do I configure the properties of the protocol NetTcpBinding in web.config?
Thankyou.
Teles
Riddhi ValechaPosted Apr 16, 2013, 2:35 AM
Other options are-
Use the concepts of LINQ/PLINQ (if possible).
In PLINQ, there is a method AsParallel().
This helps in doing two or more tasks parallely, hence completing more task in less time.
If you compare SQL and LINQ, then data processing in LINQ is better.
Use LINQ-To-SQL file - .dbml file.
Or you also can use .edmx file. i.e. Entity Data Mode.
Hope this helps.
Jignesh TrivediPosted Apr 16, 2013, 12:05 AM
agree with Javeed.
first of all check data base query performance. to improve query performance create non cluster indexes on table column which are use in where or order by clause.
also refer
http://www.sqlsteps.com/sql-tutorial-improving-query-performance
http://geekexplains.blogspot.in/2008/06/how-to-tune-sql-queries-for-better.html
which framework are used by you as data access layer? Entity framework or simple ADO.net?
Javeed M ShaikhPosted Apr 15, 2013, 12:29 PM
Did you try to run the query directly from the SQL prompt, how is the database performing to return this data to WCF? are you doing any processing at your end after you get the data from SQL?