Print Thread
htp output very slow
#33675 03/24/09 09:20 PM
Joined: Jul 2004
Posts: 592
W
Worker Offline OP
Member
OP Offline
Member
W
Joined: Jul 2004
Posts: 592
When running a test window that uses HTP to produce output, frequently the test will run in less than a second but it will take many seconds to retrieve the HTP output (from a distant server).

Is there any way to speed up the retrieval of the HTP output, perhaps using htp.get_page instead of htp.get_line?

EDIT: I am actually seeing something interesting. Looking at the network traffic it looks like for each call to get_line(N), the data retrieved for get_line(N-1) is sent back to the server along with the request. Perhaps the data is sent as the bind-value for :line? In either case, resolving this would greatly speed up retrieving HTP output so could you please investigate? I used Wireshark to see the traffic, and I will gladly provide more details if needed.

Re: htp output very slow
Worker #33678 03/25/09 08:37 AM
Joined: Aug 1999
Posts: 22,249
Member
Offline
Member
Joined: Aug 1999
Posts: 22,249
We'll check it out. Clearing the bind variable before the next call is the minimum we can do.


Marco Kalter
Allround Automations
Re: htp output very slow
Marco Kalter #33679 03/25/09 02:15 PM
Joined: Jul 2004
Posts: 592
W
Worker Offline OP
Member
OP Offline
Member
W
Joined: Jul 2004
Posts: 592
Thank you for the excellent service and support you provide on PL/SQL Developer. You're my favorite company to submit bugreports to smile

Incidentally, it looks like we have this exact same problem with an uncleared bind variable when fetching htp data in our web application. I don't think we would have ever found out about that if it wasn't also present in PL/SQL Developer. So, thank you for that as well.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.154s Queries: 14 (0.069s) Memory: 2.5028 MB (Peak: 3.0396 MB) Data Comp: Off Server Time: 2024-07-17 12:54:50 UTC
Valid HTML 5 and Valid CSS