unidac + oracle direct mode + non blocking mode
Hi,
another question around non blocking mode.
the actual working seetings
- unidac + oracle db
- direct mode
- disconnected mode
for me the non blocking mode doesn't work very smoothly as it blocks sometimes the entire main thread which the exact reason for what i try to use this mode.
I start the query (which is in a separat class) with Execute. I receive the results in the AfterFetch method where i trigger an event and pass the results to the GUI.
During this time a modal form is present to the user with a wait animation.
The exact behaviour is: after starting the query the GUI (animation - a runing timer which animates a symbol) is blocked for 1-2 secs, than is running normal. After several queries, very often, sometimes already with the 2nd query, the entire GUI is freezing and it will be released when the query is done and the results written in the GUI.
What is wrong here? I assume that in non blocking mode the query is done in a separate thread, right? Why is then the GUI blocked?