Slow response with SQL table in 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 maybe 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 app at runtime, which would explain the delay?  TIA
Who is Participating?
ste5anSenior DeveloperCommented:
It depends on you code.

Does you reuse existing connections or create a new one?
Do you open any record sets at the from creation time which are not needed?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.