pcsoft.us.windevCopyright 2026, PC SOFT31 Dec 2014 18:15:00 Z23 Dec 2014 09:51:00 ZHi all. Query execution first time take a long time (Even with optimized indexes.) , until second time same and other query's prepare data almost immediately after execution. Is possible to start query first time also in speed time of second. Than you.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49661/read.awp31 Dec 2014 18:15:00 ZI just saw this feature it implemented in V18 already...https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49661/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49661/read.awpQuery executionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49660/read.awp31 Dec 2014 17:30:00 ZICI, it looks like some cache issue indeed. And then you are looking at a black box more or less. You say there is a diferen…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49660/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49660/read.awpQuery executionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49659/read.awp31 Dec 2014 16:46:00 ZHi Arie. "First time" is when I start query for the first time. It takes more time to give me result. I also noticed , if I st…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49659/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49659/read.awpQuery executionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49653/read.awp31 Dec 2014 12:40:00 ZHi, what do you mean by "the first time"? - for each user after starting your app? - after restarting the hfsql? - otherwise…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49653/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49653/read.awpQuery executioninfopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49637/read.awp31 Dec 2014 11:45:41 ZHi, You might take a look at HOptimizeQuery (or HOptimize, there is a difference). It runs in idle time in an automatic creat…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49637/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49637/read.awpQuery executionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49643/read.awp31 Dec 2014 11:38:00 ZHi Vigo as I was saying, it depends on the queries, and on the data content... as you are not giving us any example, it's har…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49643/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49643/read.awpQuery executionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49631/read.awp31 Dec 2014 08:11:00 ZThank You for your answers. Fabrice, yes. Data file has 700-800.000 records. a) If I want to SELECT some records on same dat…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49631/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49631/read.awpQuery executionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49573/read.awp23 Dec 2014 11:20:00 ZHi ICI I guess a part of the data structure and the data are buffered the first time. Just a thought: What about making a Que…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49573/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49573/read.awpQuery executionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49572/read.awp23 Dec 2014 10:47:00 ZHi it all depends on the query and the corresponding data Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49572/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/49571-query-execution-49572/read.awpQuery execution