pcsoft.us.windevCopyright 2026, PC SOFT25 Jun 2020 12:50:45 Z4 Nov 2019 16:11:11 ZI have recently noticed that whenever I make the first call to any table in a HFSQL C/S which is on the same laptop as the program, then there is a delay of around 4.5 seconds. During this time the application is frozen, which includes animations so even if I were to put an animated icon on or a progress bar, these are frozen until the read is completed. I have tried running the first read on a new thread which works but then the next read has the same delay. I have tried using HReadSeekFirst as well as native SQL and setting up a maual connection but it makes no difference. The actual server is run on the same drive as the application so it is not an internet connection that is slowing it down. Once the first file has been read, there is no problem as all future reads and modifications are instant, it's just this first read which is making the connection. It only seems to be since upgrading to the lastest version unless I have just not noticed it before. As an indication, I added this code to see what the time delay was:- tBefore is Time tAfter is Time tBefore = Now() sSqlStr is SQL Query = [ SELECT CurrentVersion FROM Central WHERE Ref = 1 ] HExecuteQuery(sSqlStr) tAfter = Now() Trace(tAfter - tBefore) ------------------- The trace shows 4607, being 4.6 seconds. Any ideas or is this normal for a first read. If it is normal, is there a way to do it do that it does not freeze the application? Thanks Simon30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)testpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67891/read.awp25 Jun 2020 12:50:45 Zif you have a connection to a DB defined in the analysis (your test DB, by example) and that DB is NOT accessible while starting…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67891/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67891/read.awpSlow initial connection to HFSQl on same machinepeter_mcgillverypcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67887/read.awp25 Jun 2020 03:32:10 ZHi Simon, Did you ever get a resolution to this problem. I have the same issue. Thanks Peterhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67887/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67887/read.awpSlow initial connection to HFSQl on same machinepeter_mcgillverypcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67886/read.awp25 Jun 2020 03:32:09 ZHi Simon, Did you ever get a resolution to this problem. I have the same issue. Thanks Peterhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67886/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67376-slow-initial-connection-hfsql-same-machine-67886/read.awpSlow initial connection to HFSQl on same machine