Visual Basic and database query timing problems

[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

 

[Chris R. Timmons]

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.

Norm,

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

Chris.

 

[Norm]

Thanks for the tip. I will look into it.

-----Original Message-----


Norm,

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

Chris.