Click here to Skip to main content
15,745,973 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I had developed application. some reports displays more than 100 pages. that takes very long time to load than on my system.

I am using Server 2008 R2 (64 bit) and i had installed sql 2005 32bit service pack 4.

I had checked with installing visual studio 64bit but there is no improvement.

the same report takes half time to load from my system (xp 32bit and sql 2005 32bit).

I am using shared folder for running application.

So pls. tell me how to reduce the time.
Updated 24-Oct-12 19:20pm

1 solution

Pass less data over the network.

Try to pass only a certain set of data, say 10 pages at a time.
Once the user goes to the 11th page hit the database to fetch data for 10-20 pages.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900