Devart Forums

I run a lot of different queries and have run into a problem.
Most queries are very fast, but some take up to a minute.

Whilst waiting for a long running query to open, it would be nice for the user to see other queries being processed, but they can't

Tried multiple threads with one Connection, small queries blocked by long queries.

Tried multiple connections each with a thread, a long running query on one connection blocks the opening of small queries on others.

Tried different connections to different physical servers, long running Query on server A blocked query opening on server B!
Isolated problem to call on OCIStmtFetch where the blocking happened.

Any ideas? Blocking on a process level seems too restrictive, I feel there must be a way to sove this

Many thanks
Neil

Please specify the version of Oracle client you use.

8174 on the development machine.
Clients will be using anything >= 8

There are two global variables OCIThreaded and OCIMutexed declared in modue OraCall. By default
they are set to True. Please try to set them to False in initialization section of your main unit
(Only for Oracle 8 client).

That works a charm - Thanks

Will this cause any problems when client is >8?
Customers will have various versions of clients, and possibly different Oracle Homes which will be connected to at the same time.

This problem can be reproduced only using Oracle 8 client. That's why
there is no need to set these variables under client version > 8. You
can check client version using OCIVersion variable.