Reporting Doubt

[Osama Bin Gandhi]

Naa deggara oka 3 microsoft report viewer reports unnai which runs for a same stored procedure but different parameters.For some unknown reasons 2 runs fast and 1 is slow(some times it will time out).

Nenu prati sari aa stored procedure management studio lo open chesi Execute chesina tarvata the report start running faster...endukantaru?? connection issue??

Please help

[dotnetrockz]

check if there are any temp table creations or any droping temp tables....linkeds erver calls....these are all culprits sometimes....