WCF Performance

Question

We have a table in our database that contains about 2,500,000 rows (about 3 GB). Is it technically possible to view the data in this table in a silverlight application that requests this data using WCF? Potentially, I see problems with the maximum buffer size and timeout errors. We may need all the data that will be used for visualization.

Please guide me if there is a practical solution to this problem.

Answer 1

Moving 3 GB to the client will not work.

for visualization purposes.

It is better to prepare server visualization. It will be slow enough.

Answer 2

, , , . , WCF , , / .

, , / , 2,5 .

Answer 3

, .

3 , . , , - WCF .

, , / , ? Silverlight, 3 ( 64- ), , . , .

:

• / , . , OLAP,...
• .
• ,

Answer 4

, , 2,5 .

, WCF.

WCF , , - N- SOA- - , , .

:

• OR/M. NHibernate , , LINQ API QueryOver NHibernate 3.0. , 2,5 .

• . NHibernate , , (Web, Windows...), (, ASP.NET, ).

• , WCF: SOAP JSON? , JSON, , .

, !

Answer 5

, , , , - , , ?

• 2,5 . . 80 ( sdcreen, 90 ), 31250 . . - (!) .., . , , . , , . , .

• , . . ONE PIXEL , 1,33 1024 * 768 . .

So, at the end of the day, even if (this is not possible), to cope with this, you get an insensitive / unusable application.