Is my understanding accurate that SQLSelect and SQLExecute calls from within a non-main thread do not block any thread other than the one from which they are called? If so, is it accurate for all databases supported by Xojo?
Is there any database performance penalty when calling SQLSelect and SQLExecute from a non-main thread versus the main thread?
Calls from threads should yield for the built in database plugins.
At least that was a feature announced some time back.
But due to the yield, the performance is a little bit slower on a thread compared to main thread where they don’t yield.
[quote=62588:@Christian Schmitz]Calls from threads should yield for the built in database plugins.
At least that was a feature announced some time back.
But due to the yield, the performance is a little bit slower on a thread compared to main thread where they don’t yield.[/quote]
Thanks Christian!