September 27, 2007, 03:36 PM
SyedYup - I tested it for the data. It takes about 20 seconds to get the data (when I tried to comment out the hold part and displaying the data in a normal HTML page). The remaining time (close to 2 minutes) is spent in generating these HTML tags.
I'm trying to move these conditional tags to the HTML page (using javascript), but this will take a lot of effort. Is there any way I can speed up the tag generation?
Syed
September 28, 2007, 09:41 AM
TexasStingrayNot sure I under stand what you did last. Did you do all the computes, create the tags, and just hold the data to a file and not send it all back to the browser. If you did all that then it has got to be a network traffic issue. To verify that it is a network traffic issue, Try this test save it to a file that can be accessed from the webserver. once it is finished then open up a new browser and put the accress to the file in the url and see how long that takes.
Scott
October 01, 2007, 01:47 PM
SyedHi
Actually I'm using FORMAT WP to hold the data in a Word Processing format so that the formatting (tag generation) happens before and the browser just displays the formatted data.
However, it looks like this process (generation of tags) is taking a lot of time.
When I comment out the statement - ON TABLE HOLD FORMAT WP, and try to display in the regular HTML format, the processing happens pretty fast! This is the reason why I pointed out to the tag generation.
Let me know if you have any pointers.
Using WF 7.1.7/Dev Studio
October 01, 2007, 02:14 PM
Francis MarianiI'm not sure why you're using WP as the HOLD format.
Wouldn't ALPHA work? Here's an example:
SET HOLDLIST=PRINTONLY
RUN
TABLE FILE CAR
PRINT
COMPUTE LINE/A100 = '<TR><TD CLASS=C1>' || COUNTRY || '</TD><TD>' || CAR || '</TD><TD>' || MODEL || '</TD></TR>';
ON TABLE HOLD AS H001 FORMAT ALPHA
END
-RUN
-HTMLFORM BEGIN
<STYLE>
BODY { FONT-FAMILY: ARIAL, SANS-SERIF; FONT-SIZE: .8EM; }
TD { FONT-SIZE: .8EM; BORDER: 1PX SOLID LIGHT-GRAY; }
TABLE { BORDER-COLLAPSE: COLLAPSE; }
.C1 { COLOR: GREEN; }
.T1 { FONT-WEIGHT: BOLD; }
</STYLE>
<TABLE BORDER=0>
<TR><TD CLASS=T1>COUNTRY</TD><TD CLASS=T1>CAR</TD><TD CLASS=T1>MODEL</TD></TR>
!IBI.FIL.H001;
</TABLE>
-HTMLFORM END
This does pretty much what you are doing. Are you using WP for page heading and numbering purposes?
My two thousandth posting! Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 01, 2007, 02:31 PM
ETTwo thousandth posting!! Since IBI won't pay you they should at least give you a free pass to next years Summit wherever that may be.
ET
FOCUS 7.6 MVS PDF,HTML,EXCEL
October 01, 2007, 04:42 PM
SyedCongrats on your 2000th posting!!
ALPHA worked just fine. I was thinking that WP would be needed for generating those tags
However, the performance is still the same.
Can you let me know why is it taking so much time to generate the tags and display them on the browser?
Using WF 7.1.7/Dev Studio
October 01, 2007, 05:36 PM
Francis MarianiIs it possible that is has something to do with the "through Citrix" part of your infra-structure?
Have you tried printing the data, but without the TR and TD tags, just to see if the same number of data rows get returned faster?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 01, 2007, 06:00 PM
SyedAlmost the same time
. It looks like it is a lot of data, which is why its taking somuch time to get the output.
Using WF 7.1.7/Dev Studio
October 01, 2007, 06:03 PM
SyedOops!! I just commented out the FORMAT ALPHA part, and its taking just 14 seconds to get the o/p in the default format.
Which means the tags are creating this issue.
Using WF 7.1.7/Dev Studio
October 02, 2007, 11:18 AM
Darin LeeJust one question - since WF provides "accordion" functionality to expand/contract lines, wouldn't it be better to use that than jump through all the hoops to reinvent the wheel? Maybe you already looked at it and it wasn't what you needed?
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat