pcsoft.us.windevCopyright 2026, PC SOFT6 Dec 2018 16:59:02 Z22 Jul 2016 11:46:00 ZHi, I have a stopwatch in my application before I call HEXECUTEQUERY() and after Tabledisplay() I stop the watch. I found a funny behaviour (local or over the internet, different databases, all the same) The first call is quit fast (1-2 seconds), the next calls taken 5-6 seconds. Whats the reason ? IMHO HF SQL should be faster after the first call (cache). Any ideas ? -------------------------------------- Mmh, it looks like that the Problem is "tabledisplay". It tooks 5 times longer after the first call.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Joris_Martenspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-66919/read.awp6 Dec 2018 16:59:02 ZHi, Today I have noticed the same problem in a WD23 project using HFSQL client/server version 23. The first time i run the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-66919/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-66919/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58867/read.awp27 Jul 2016 08:31:00 ZHi Derek, I use the AAF Tablesort in the header of the table. Every user understand, how to use it :-)https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58867/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58867/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58862/read.awp26 Jul 2016 21:44:00 ZQuote Michael Drechsel Hir Derek, ok, but what´s the difference between "your" memory solution and "PC Softs loaded i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58862/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58862/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58858/read.awp26 Jul 2016 14:54:00 ZHir Derek, ok, but what´s the difference between "your" memory solution and "PC Softs loaded in memory" ? It´s both memory .…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58858/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58858/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58855/read.awp26 Jul 2016 14:46:00 ZMichael Hows about defining a array based on a structure and bind the table to the array hexecutequery(QryNoname1) FileTo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58855/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58855/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58853/read.awp26 Jul 2016 13:59:00 ZHi Jose, I defined a special sort option ("ignorecase") for all my string fields, maybe this is the reason.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58853/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58853/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58852/read.awp26 Jul 2016 13:35:00 ZHi Michael. So as you said the this behavior happens also on local database hfclassic, so i did a test: I have a query of ab…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58852/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58852/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58838/read.awp25 Jul 2016 20:21:00 ZHi Fabrice, nope. If I don´t use Mytable..BrowsedFile="" the whole process takes 5 secondes, with that only 1-2 seconds. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58838/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58838/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58837/read.awp25 Jul 2016 19:40:00 ZHi Michael, I wonder if you measured the time needed for the Mytable..BrowsedFile="". This SHOULD be equal to your time diffe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58837/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58837/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-solved-58814/read.awp23 Jul 2016 08:37:00 ZOk, here a solution: Put a Mytable..BrowsedFile="" before the "HEXECUTEQRY" and then a Mytable..BrowsedFile=MyQue…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-solved-58814/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-solved-58814/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58815/read.awp23 Jul 2016 08:07:00 ZHi Stefan, yes, it makes no difference. The table has ~6.500 rows. It looks like that tabledisplay (delete+fill) take s…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58815/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58815/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58812/read.awp23 Jul 2016 06:09:00 ZHmmmmm, I have also observed this behavior that is after first call to TableDisplay the consecutive calls to TableDispaly see…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58812/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58812/read.awp[WD2X] Performance of HF SQL Serverguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58809/read.awp22 Jul 2016 17:24:00 ZHi Michael, do you use MyTable..DisplayEnabled = False before and MyTable..DisplayEnabled = True after TableDisplay()?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58809/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58805-wd2x-performance-sql-server-58809/read.awp[WD2X] Performance of HF SQL Server