Sorting issue for remote users

[Sanjai]

Hi,

I have an issue with a report which is running really slow. The application is running from the server in LA. I have some users in Indianapolis. The connection there has been a little slower than what users get in LA. I have designed a new report which contains summary part to show group data.

I have created a script to run this report where I first find the data, navigate to the report layout and sort the data. I have experienced in the past that sorting has always resulted to make the application slower in Indianapolis.

The report needs to be shown with the grouped data and hence I believe that sorting is important. But this time the report generation has become much slower. However the rest of the tools are working fine. Is there a way someone can suggest how to improve the process.

I tried removing the sort script step. It works at a good speed for remote users but the data is not grouped.

When we sort, I believe that the sorting process runs on the client completely and since the client's workstation has good hardware configuration, it should not be a problem. While sorting, is there any exchange of data between the server and the client?

Thanks,

--Sanjai

[Reed]

Sorting is network intensive, so the only way to speed this up is to have the remote users connect to the server using timbuktu, or some other desktop sharing program, or by using terminal services or Citrix. This way all the network intensive stuff happens on the LAN, and only keyboard and video information is sent to remote users.

Also, make sure you do your sorts on the found set that you want in the report, rather than sorting the whole database, and then constraining the found set. It will be much faster this way.

Dana

[Sanjai]

Thanks for your answer. I would see how I can make the remote users connect to the server.

Yes, I am doing all the find operations first and the sorting is done on the foundset which I need for the report.

If someone else can think of other solutions to improve my process from the programming/application side, it would be helpful.