pcsoft.us.windevCopyright 2026, PC SOFT24 Jan 2015 16:17:00 Z22 Jan 2015 22:42:00 ZHi, today I got a urgent mail from one of my customer: The HF SQL Server is not responding. After some tests with a copy of the database at my developer laptop I saw the reason: I have a query with a lot of parameters, 4 or 5 with "is in the list". My lists are GUIDs (32 chars+";"). If the user chooses 3 of theses parameters, the query returns an answer after 5 seconds, if he clicks also the 4 th parameter the HF SQL Server has 25 % utilisation and never returns an answer. The parameters are not the reason, 3 at the same time working, 4 not. The only way to stop this is to restart the hf sql server. Any ideas ?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50067/read.awp24 Jan 2015 16:17:00 ZHi Piet, I know. But my current problem has to do with the "intelligence" of the hf sql server. Lets say you have two file…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50067/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50067/read.awp[WD17] I shot down the HFSQL Server with a Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50063/read.awp24 Jan 2015 11:39:00 ZHi Michael, You can create a query in the editor and copy and paste the SQL code to text to tweak it. I use hExecuteSQLquery…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50063/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50063/read.awp[WD17] I shot down the HFSQL Server with a Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50035/read.awp23 Jan 2015 11:15:00 ZHi Derek, finally I solved it. My query joins 5 files and I moved some of the the parameters to other (=source) files. Maybe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50035/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50035/read.awp[WD17] I shot down the HFSQL Server with a Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50030/read.awp23 Jan 2015 10:57:00 ZMichael Had a similar problem, although the sever never refused to respond, when using multiple options submitted as a 'CONTA…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50030/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50030/read.awp[WD17] I shot down the HFSQL Server with a Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50027/read.awp23 Jan 2015 09:30:00 ZHi Allard, My tables have always a key with a GUID. If the user want to get information about more then one item I add the GU…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50027/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50027/read.awp[WD17] I shot down the HFSQL Server with a Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50026/read.awp23 Jan 2015 09:22:00 ZHih ow do you define your list. I use list as well and have hd no problems so far regards Allardhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50026/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50026/read.awp[WD17] I shot down the HFSQL Server with a Queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50025/read.awp23 Jan 2015 08:47:00 ZHi Michael, not direct a solution, but WD20 should be optimized for the use of "is in the list" parameters.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50025/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50017-wd17-shot-down-hfsql-server-with-query-50025/read.awp[WD17] I shot down the HFSQL Server with a Query