appl'n not responding mode

[Nparag]

hi folks
I am using VB5 with oracle as backend. I am doing some complex mathematical calculations which are very data centric. i have to use many loops each involving some database access. My application stays in not responding mode for lot of time. Is it because of the database access of anything else and what will be the solution for this problem.
Thanx in advance

I am assuming that your query (in vb code itself)is composed of queries within queries so this problem is not unusual. How you access the database? I would rewrite simple more that one queries instead of one big complex one to solve your problem. e-mail me at [email protected] for details. GoodLuck!!