Slow Performance in OWC10

[Jack]

I am using OWC10 in a VB .Net application. The performance of the OWC is ok
while it is like 10k data. When the data growth to more than 20k, the
performance starting to become slow. The user just click on the "+" to expand
data in detail area will use about 30 minutes. Furthermore, when the user
move th scroll bar with data expanded in the detail area, it will take
another 20 to 30 minutes...

I've tried to change to OWC11 but it is the same. I know the data is too
large t be display in OWC, but is there any other work around for this? I've
been serching the solution for months but nothing I can found. Many people
has been asking the same question but end up not getting any solution. Anyone
here can help please?

 

[Alvin Bruney - ASP.NET MVP]

The solution, as repeatedly posted, is to narrow down the amount of data
being returned to the user. Not thru the OWC but in the data source layer.
Filtering doesn't mean that the filtered out data in the OWC is not present.
it is present, it is just not visible. That still leads to performance
problems.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006