Link to home
Start Free TrialLog in
Avatar of sasllc
sasllcFlag for United States of America

asked on

Slow response with SQL table in vb.net app

When the user opens one of the forms there is a long delay.  I have found that one of the SQL tables is much larger than most users ever encounter.  It is a table that is only opened in some cases in the code for this form, but when this slowdown happened, it made me wonder if 'something' is happening with that table as we start the form...like maybe vb.net does some type of "pre-fetch" or "pre-something" just in case that table DOES get opened.  Note that this is in the compact framework environment.

So is anyone familiar with the "inner workings" of a vb.net app at runtime, which would explain the delay?  TIA
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial