By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,507 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

What can slow down VB.NET windows database applications

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a


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

Nov 20 '05 #2

P: n/a
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
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.