Re: 2 Performance Questions

From: Samuel Kim (look341_at_gmail.com)
Date: 03/03/05 

Date: 3 Mar 2005 03:17:35 -0800

1. If your datagrid contains a large amount of data, then your view
state will be considerably large. This can be checked by viewing the
source code from your browser. If this data is significantly large,
then the page download as well as postback will take time. Also, the
viewstate then needs to be de-serialized on the server each round-trip
adding extra overhead.

I am assuming that a postback takes place - this is probably true
unless you are using some clever javascript to show and hide the cell.

If the above is the issue, then you will have to not load all the
nested grids on page load, but should load them as the "down arrow" is
clicked.

2. Very strange and this may have to do with the way you are
configured.
I recommend that you enable trace (if you have not already done so) or
run the code in debug mode to see which step takes up the time. If it
is the actual SQL call that takes up the time, then you would look at
the network connectivity, compare other db calls, running the stored
proc from query analyser etc... If slowness is caused from elsewhere in
the code, then that is a separate matter.

With the two issues above, you may like to have a look at the network
speed - as both symptoms can be caused by a slow network. E.g. are you
accessing the server on a slow connection?

Hope this helps.

Relevant Pages

  • Re: 2 Performance Questions
    ... >If the above is the issue, then you will have to not load ... >the network connectivity, compare other db calls, running ... >speed - as both symptoms can be caused by a slow network. ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Archiving old data to improve performance
    ... If you load up a form with a 'where' clause to open up that one reocrd, ... IF YOU HAD ONLY 10 reocrds. ... With 5 to 10 users on a network, ... and then opens it..and the throws this form attached to ...
    (microsoft.public.access.modulesdaovba)
  • Re: workgroup is not accessable; the network is not present or not
    ... The workstation service terminated with service specific error 2250 ... Could not load RDR device driver ... not see any of the other machines on the network. ... > Have you used Event Viewer to see what events or error ...
    (microsoft.public.win2000.networking)
  • Re: [SLE] eth0 now eth1 WTF? Network woes....The saga....[Long]
    ... > Then on a subsequent reboot the network doesn't come up. ... but the NIC fails to load and the error is "unable to load ... > On reboot, the network fails. ... dmesg says it is now trying to load eth1? ...
    (SuSE)
  • Summary:Configure Network interfaces for best utilization
    ... Netbackup Datacenter 4.5 trying to configure network interfaces for best ... read on a previous summary that IPMP only works on outbound traffic for load ... > I'm thinking about is Sun trunking. ...
    (SunManagers)