What can slow down VB.NET windows database applications

  • Thread starter Thread starter Jelena B
  • Start date Start date
J

Jelena B

What could be the common or possible reasons that can slow down an
VB.NET windows database (SQL Server) application. What is the normal
time needed for such an application to initialize and show is first,
start up form.

I used stored procedures for every communication with database and the
biggest DataTable I use have 80 rows and 5 columns, no images, no
multimedia, only digits and short texts.

Why it takes so long to rize in the first attempt and every other
attemp is 2 times quicker.

The same problem appears with Reports made with Crystal Report
Designer.

Crystal Report is populated with data from DataTable object, that is
populated with DataReader that is then result of ExecuteRader method
of command object that execute stored procedure. What is more, there
is so few data to print that there is only one page od report.

Thanks, Jelena
 
Hi,
The first time you load a .Net application, the clr has to initialize and
then will load your application. The second time around you wont see this
delay. The other reason why your app could be slow is, if you have the
database connectivity code in the formload and basically if it is
populating a datagrid then it may take a while.


Anand Balasubramanian
Microsoft, Visual Basic .NET

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to newsgroups only. Thanks
 
I found out the same. I just wondered if there is a way to avoid such
a slow initialization, but it seems that that is so no matter how I
whrite code.

Thanks for concern, Jelena
 
Back
Top