pcsoft.us.windevCopyright 2026, PC SOFT24 Jul 2018 11:50:06 Z23 Aug 2016 15:49:30 ZI got myself a heavy duty query that takes about 10-20 seconds to execute. So of course I moved the query into a separate, background thread and just had it populate a collection of data structures and I set my thread-mode to Multi-Processor and Critical-Section. This is wonderful -- the query executes in the separate thread and my GUI is still responsive and whatnot. HOWEVER -- if I were to execute a query on the main thread (a small, itty-bitty query) while the background-thread's query is executing, the main thread hangs up. It needs to wait for the background-thread's query to finished executing before it can execute the main thread's query. So, I thought that was a bit odd and that maybe it was a problem on the server/database side not being able to handle 2 connections belonging to the same process. So I forced the background-thread to connect to a different server. But that did not change anything at all. So now my question --- is there a mutex on the function HExecuteSQLQuery in the WinDev framework? - or what else would be preventing me from having 2 queries execute at the same time on completely different servers and databases?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)BigEDpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-66326/read.awp24 Jul 2018 11:50:06 ZDid you ever find a solution for this problem? I have similar issue with NativeMYSql connection. Best regards!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-66326/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-66326/read.awp[WD21] - Question concerning connections & queriesAndrewpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-59205/read.awp24 Aug 2016 13:20:22 ZYup - I'm using threadFullCopyHFSQLContext in my ThreadExecute() call.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-59205/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-59205/read.awp[WD21] - Question concerning connections & queriesfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-59182/read.awp23 Aug 2016 18:38:45 ZHi Andrew, is your secondary thread using a separate HF contect or not? Best regards -- Fabrice Harari International…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-59182/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59179-wd21-question-concerning-connections-queries-59182/read.awp[WD21] - Question concerning connections & queries