Sergey:
I can't find the improvement on edit or add page in the New Version 3.2 regarding the Look Up Wizards.
We need this because it runs so slow loading the drop down boxes on edit or add new records. Sometimes the save is slow too.
We are using:
MS SQL Server 2000
MS Windows 2003
Dell a Very Powerful Server
ASPRunner with Drop Down Boxes for Record Id # with thousands of rows.
W3WP.EXE Consumes too much CPU when it runs and after a lot of tests the Admins sayd definitely is the Aplication. What should I do??????Thx
LILIAN
This microsoft articule says
SYMPTOMS
You may notice that your production Web server has 100 percent CPU utilization and slow response times, even under light load.
Back to the top
CAUSE
This problem frequently occurs when your application performs many string concatenations, such as dynamically building HTML or XML strings. In this scenario, Aspnet_wp.exe (or W3wp.exe , for applications that run on IIS 6.0) is the offending process. You can see evidence of this problem in Task Manager on the Processes tab or in the Performance Monitor counter.
Back to the top
RESOLUTION
Use one of the following methods to resolve this problem.
Solution 1
Use the System.Text.StringBuilder class to perform the concatenations. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
306821 HOW TO: Improve String Concatenation Performance in Visual Basic .NET
Solution 2
Use the Response.Write method (for Web Forms) instead of concatenation to stream the text.
