>>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.
>
>Having all data displayed it's very quick to search by number/data/client/.. and answer i.e. a phone request...
>
>In fact, I might agree with you, but at present I'm looking for a technical solution.
>
>Bruno
>
>
>
>>>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.

What part of the performance is "slow" - retrieving the data, or displaying/navigating through it? I ask because in the past I've had users complain of "bad performance", when they're scrolling to the bottom of a grid with many rows by clicking on the down arrow and holding it down, rather than dragging the thumbnail or clicking between the thumbnail and the down arrow. Sometimes with issues like that it's just a matter of a few minutes' training.

You say you have a workstation where performance is good. Can you test what the performance is like while remote-controlling that workstation? That will isolate whether it's a problem with Remote Desktop or whether it's lower performance in the Windows 2008 R2 session compared to the separate PC workstation.