Recent Posts
41
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 25, 2025, 06:08:01 AM »Hi Bruce
Thanks for the reply.
Are you referring to the code in the "Client Side" server code button embed
the only code I have there executes super fast.
ds_OutputDebugString('TVCweb MyCode Start:' & format(clock(),@t06))
do calc_rest_of_flds
ds_OutputDebugString('TVCweb MyCode End:' & format(clock(),@t06))
Or is there code somewhere else that is still executing on a thread even though the page is populated?
thanks
Johan
Thanks for the reply.
Are you referring to the code in the "Client Side" server code button embed
the only code I have there executes super fast.
ds_OutputDebugString('TVCweb MyCode Start:' & format(clock(),@t06))
do calc_rest_of_flds
ds_OutputDebugString('TVCweb MyCode End:' & format(clock(),@t06))
Or is there code somewhere else that is still executing on a thread even though the page is populated?
thanks
Johan
42
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by Bruce on July 25, 2025, 05:08:46 AM »These are just timer events in the NetTalk DLL.
They're unrelated to your issue.
My guess is that the reply to the browser is not completing. ie you have some code in the thread, after the drop down is populated, which delays the ending of the thread. In that case the connection is not closed, so the browser does not start processing the reply.
Cheers
Bruce
They're unrelated to your issue.
My guess is that the reply to the browser is not completing. ie you have some code in the thread, after the drop down is populated, which delays the ending of the thread. In that case the connection is not closed, so the browser does not start processing the reply.
Cheers
Bruce
43
Web Server - Ask For Help / How to debug this slow request?
« Last post by JohanR on July 25, 2025, 03:46:25 AM »Hi,
I have a browse list with EIP on a dropdown to update the item qty
Only the row is updated currently.
I have also attached a debug logfile of when I click the dropdown to when the page is updated.
The update code is super quick, but lines below is the problem.
How and where can I debug this?
These lines in the attached debug log take 7secs to execute with the busy wheel displaying
Currently trying the browser devtools to see but was hoping there might be some feedback from someone.
thanks
Johan
63 13:20:21.239 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
64 13:20:21.239 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
65 13:20:22.249 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
66 13:20:22.249 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
67 13:20:23.240 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
68 13:20:23.240 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
69 13:20:24.242 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
70 13:20:24.242 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
71 13:20:25.239 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
72 13:20:25.239 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
73 13:20:26.241 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
74 13:20:26.242 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
75 13:20:27.246 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
76 13:20:27.246 28064 xtvcweb.exe [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
I've had a similar issue before with a different procedure and when I reworked the procedure it resolved the issue without me knowing what caused the problem.
44
Web Server - Ask For Help / Re: Webserver performance slow after restart
« Last post by osquiabro on July 25, 2025, 03:41:55 AM »try in your conection strings this
DRIVER={SQL Server Native Client 11.0};VERIFYVIASELECT=True;MARS_Connection=Yes;BUSYHANDLING=2
very important that sqlclient version 11 is intalled
my site is multi host https://istpr.com/
GPF Report is a good tool for this problems, i think the problem is a an embedded code a not NT.
I'm on version 14.22 with no major issues. Only on very rare occasions does a gpf report point to xfiles, and I've never been able to resolve it.
DRIVER={SQL Server Native Client 11.0};VERIFYVIASELECT=True;MARS_Connection=Yes;BUSYHANDLING=2
very important that sqlclient version 11 is intalled
my site is multi host https://istpr.com/
GPF Report is a good tool for this problems, i think the problem is a an embedded code a not NT.
I'm on version 14.22 with no major issues. Only on very rare occasions does a gpf report point to xfiles, and I've never been able to resolve it.
45
Web Server - Ask For Help / SOLVED - Re: Multi-Site host flashes error message
« Last post by jking on July 24, 2025, 11:19:54 AM »Hello all,
Turns out this was due to a report being generated. Users click on a button to generate the report and it is converted to PDF. The Report to PDF template displays a brief message on the server to indicate the report processing. The report is not used all that often, until recently, and I had not seen this screen flash by before. All is good!
Jeff King
Turns out this was due to a report being generated. Users click on a button to generate the report and it is converted to PDF. The Report to PDF template displays a brief message on the server to indicate the report processing. The report is not used all that often, until recently, and I had not seen this screen flash by before. All is good!
Jeff King
46
Web Server - Ask For Help / Re: Webserver performance slow after restart
« Last post by TimR on July 24, 2025, 07:58:48 AM »14.26, the issue has been ongoing over several versions, this is a multi host server, many databases used
47
Web Server - Ask For Help / Re: Multi-Site host flashes error message
« Last post by jking on July 24, 2025, 06:12:16 AM »Johan,
Thanks for the response. I don't think this is a MessageBox screen as it is too small. Thinking about it more, it reminds me of messages I used to see when using FileManager. I'll check my host app to see if FM is in use, but it is not something I regularly use.
As for logging, anything in particular I should look for in the logs if I turn those on?
Thanks,
Jeff
Thanks for the response. I don't think this is a MessageBox screen as it is too small. Thinking about it more, it reminds me of messages I used to see when using FileManager. I'll check my host app to see if FM is in use, but it is not something I regularly use.
As for logging, anything in particular I should look for in the logs if I turn those on?
Thanks,
Jeff
48
Web Server - Ask For Help / Re: Multi-Site host flashes error message
« Last post by jking on July 24, 2025, 06:08:55 AM »Ron,
Thanks! I'll message him and see what he thinks.
Jeff
Thanks! I'll message him and see what he thinks.
Jeff
49
Web Server - Ask For Help / Re: Webserver performance slow after restart
« Last post by osquiabro on July 24, 2025, 03:31:34 AM »what version of NT? i have a large database about 1tb in SQL and NT without any problem.
But I never use tps
But I never use tps
50
Web Server - Ask For Help / Re: Multi-Site host flashes error message
« Last post by JohanR on July 24, 2025, 02:17:51 AM »Hi Jeff
If it is a MessageBox screen perhaps the time is too short.
It's 100's of a second, try to increase, and there are also logging options
regards
Johan
If it is a MessageBox screen perhaps the time is too short.
It's 100's of a second, try to increase, and there are also logging options
regards
Johan