>I’ve an application which work extracting (from SqlServer) all invoices of the current year and present them in the main grid (I can limit the number i.e. the last 100 ones, but my client want to see them all).
>Near the end of the year the number of records extracted is more than 5000.
>No problem while accessing the program from a PC in the network: it’s fast.
>But when accessing through remote desktop (on Win2008 R2), it slows down considerably.
>I’m asking how to improve performance: which settings and so on.
The user will not see 5000 records at the same time; you should be able to show data a month at a time, for example.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)