Recent Posts
51
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 30, 2025, 03:07:59 AM »Hi,
Currently have had to remove the EIP dropbox and replaced it with a popup UpdateForm.
Will return to the problem when I get a chance, and will post any findings.
thanks
Johan
Currently have had to remove the EIP dropbox and replaced it with a popup UpdateForm.
Will return to the problem when I get a chance, and will post any findings.
thanks
Johan
52
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 29, 2025, 10:27:15 AM »Hi Bruce
Any advice on how to find this possible problem?
Been chasing all sorts of things past few days, but still having an issue.
From your post earlier
>>>>>>>>>>>>>>>>>>>>
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.
>>>>>>>>>>>>>>>>>>>>
thanks
Johan
Any advice on how to find this possible problem?
Been chasing all sorts of things past few days, but still having an issue.
From your post earlier
>>>>>>>>>>>>>>>>>>>>
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.
>>>>>>>>>>>>>>>>>>>>
thanks
Johan
53
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 27, 2025, 09:50:16 PM »Hi Ron
thanks for the idea, am looking into it.
The key is Case sensitive and the filter is constructed by the EIP code
My understanding is if Case sensitive key then UPPER not required?
thanks
Johan
54
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by rjolda on July 27, 2025, 03:04:05 AM »Johan,
I am not sure if it applies here but using the UPPER on any searches really speeds up browses.
e.g instead of where ITM:UID = thisUID go for where UPPER(ITM:UID) = UPPER(thisUID). This takes out the mixed case filtering and speeds up queries.
Ron
I am not sure if it applies here but using the UPPER on any searches really speeds up browses.
e.g instead of where ITM:UID = thisUID go for where UPPER(ITM:UID) = UPPER(thisUID). This takes out the mixed case filtering and speeds up queries.
Ron
55
Web Server - Ask For Help / Re: How to debug this slow request?
« Last post by JohanR on July 26, 2025, 12:43:26 AM »Hi Bruce
Think I found the line that takes roughly 5secs
In the LoadViewRecord
It's the next(p_view) between 5555 and 6666
Still using TPS, not sure if this is an issue
Below the code and the view structure.
My next step is going to duplicate and handcode the action of the view and see if it does the same and also to see if there is something to be done.
Any ideas highly appreciated.
Johan
NetWebServerWorkerBase.LoadViewRecord Procedure(View p_View,File p_File,Key p_Key)
err Long
f String(1024)
code
self.trace('TVCweb LoadViewRecord 1111:' & format(clock(),@t06))
f = p_view{prop:filter}
self.trace('TVCweb LoadViewRecord 2222:' & format(clock(),@t06))
p_view{prop:filter} = ''
self.trace('TVCweb LoadViewRecord 3333:' & format(clock(),@t06))
self.trace('TVCweb LoadViewRecord 3333Filter=:' & p_View{prop:filter})
self.AddKeyToFilter(p_View,p_File,p_Key)
self.trace('TVCweb LoadViewRecord 4444:' & format(clock(),@t06))
self.trace('TVCweb LoadViewRecord 4444Filter=:' & p_View{prop:filter})
set(p_view)
self.trace('TVCweb LoadViewRecord 5555:' & format(clock(),@t06))
next(p_view)
self.trace('TVCweb LoadViewRecord 6666:' & format(clock(),@t06))
err = errorcode()
self.trace('TVCweb LoadViewRecord 7777:' & format(clock(),@t06))
p_view{prop:filter} = self.AssignFilter(f)
self.trace('TVCweb LoadViewRecord 8888:' & format(clock(),@t06))
return err
View:item View(item)
Project(ite:item_isn)
Project(ite:item_desc)
Project(ite:item_amt)
Project(ite:item_qty)
Project(ite:item_gr_total)
END ! of ThisView
Think I found the line that takes roughly 5secs
In the LoadViewRecord
It's the next(p_view) between 5555 and 6666
Still using TPS, not sure if this is an issue
Below the code and the view structure.
My next step is going to duplicate and handcode the action of the view and see if it does the same and also to see if there is something to be done.
Any ideas highly appreciated.
Johan
NetWebServerWorkerBase.LoadViewRecord Procedure(View p_View,File p_File,Key p_Key)
err Long
f String(1024)
code
self.trace('TVCweb LoadViewRecord 1111:' & format(clock(),@t06))
f = p_view{prop:filter}
self.trace('TVCweb LoadViewRecord 2222:' & format(clock(),@t06))
p_view{prop:filter} = ''
self.trace('TVCweb LoadViewRecord 3333:' & format(clock(),@t06))
self.trace('TVCweb LoadViewRecord 3333Filter=:' & p_View{prop:filter})
self.AddKeyToFilter(p_View,p_File,p_Key)
self.trace('TVCweb LoadViewRecord 4444:' & format(clock(),@t06))
self.trace('TVCweb LoadViewRecord 4444Filter=:' & p_View{prop:filter})
set(p_view)
self.trace('TVCweb LoadViewRecord 5555:' & format(clock(),@t06))
next(p_view)
self.trace('TVCweb LoadViewRecord 6666:' & format(clock(),@t06))
err = errorcode()
self.trace('TVCweb LoadViewRecord 7777:' & format(clock(),@t06))
p_view{prop:filter} = self.AssignFilter(f)
self.trace('TVCweb LoadViewRecord 8888:' & format(clock(),@t06))
return err
View:item View(item)
Project(ite:item_isn)
Project(ite:item_desc)
Project(ite:item_amt)
Project(ite:item_qty)
Project(ite:item_gr_total)
END ! of ThisView
56
Web Server - Ask For Help / NT14 CLALIT2 - NetwebForm - Duplicate Record
« Last post by David on July 25, 2025, 03:58:52 PM »I've got a NT14 webserver with a netwebbrowse / form based on a SQLite table using the new Driver Kit. When I attempt to update a record, the form save returns an error message "creates duplicate record...." I've attached a screenshot. The browse and form both use a GUID field as their unique key. Any suggestions on where to troubleshoot this? Thank you.
I've done some additional testing....
Change the database driver to TopSpeed, recompile, netwebform functions fine
Change the database driver to SQLite (Softvelocity), recompile, netwebform funtions fine
Change the database driver to SQLite2 (DriverKit), recompile, netwebform presents "creates duplicate record" error
I've done some additional testing....
Change the database driver to TopSpeed, recompile, netwebform functions fine
Change the database driver to SQLite (Softvelocity), recompile, netwebform funtions fine
Change the database driver to SQLite2 (DriverKit), recompile, netwebform presents "creates duplicate record" error
57
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
58
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
59
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.
60
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.