htp output very slow

[Worker]

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.

 

[Marco Kalter]

We'll check it out. Clearing the bind variable before the next call is the minimum we can do.

 

[Worker]

Thank you for the excellent service and support you provide on PL/SQL Developer. You're my favorite company to submit bugreports to

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.