Visual Basic and database query timing problems

  • Thread starter Thread starter Norm
  • Start date Start date
N

Norm

I have run into problems from time to time (and this is
one of those times) using visual basic to access an
external database and perform a basic select from
statement. When the table is extremely large and
performance low, the application freezes. It seems that
it is timing out. Recently I was trying to hit an oracle
database and got the same problem. In this case, I query
a view. When I query a view on a large database, the
progam hangs and never comes back. When I query on a view
on a smaller database, the app runs fine. One solution
may be to create a materialzied view so that my app does
not have to wait for the regular view to finish
executing. However, I wonder if I can control the timing
in my vb app. I am using the current version of visual
studio.net. Is there a way to solve such a problem in
visual basic? Can I make the app wait longer.

Thank you
 
I have run into problems from time to time (and this is
one of those times) using visual basic to access an
external database and perform a basic select from
statement. When the table is extremely large and
performance low, the application freezes. It seems that
it is timing out. Recently I was trying to hit an oracle
database and got the same problem. In this case, I query
a view. When I query a view on a large database, the
progam hangs and never comes back. When I query on a view
on a smaller database, the app runs fine. One solution
may be to create a materialzied view so that my app does
not have to wait for the regular view to finish
executing. However, I wonder if I can control the timing
in my vb app. I am using the current version of visual
studio.net. Is there a way to solve such a problem in
visual basic? Can I make the app wait longer.
Click to expand...

Norm,

Execute the query on a thread (System.Threading.Thread).

Chris.
 
Back
Top