Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filedef the big guys

Status
Not open for further replies.
nonskanse

nonskanse

Programmer
Jan 7, 2004
9
US
Hi! I am trying to filedef something similar to the below. I am however not as familiar with the filedef method as other methods. I would like to know:
1a- how to filedef compound documents because the below runs a little slow (surprise surprise), possibly in a loop for different areas (to get a file &area1.pdf). I would like to place these files on the server
1b- How to get to the filedef'd &area1.pdf (&area2.pdf, etc) once on the server.

I apologize for the huge question here, but this fex takes a bit over 30 seconds to run on a good day when the server isn't busy.

SET COMPOUND=OPEN NOBREAK
EX APP/prog1
SET COMPOUND=NOBREAK
EX app/prog2
EX APP/prog3
SET COMPOUND = NOBREAK
EX APP/graphpg1
EX app/graphpg2
SET COMPOUND=CLOSE
EX app/graphpg3
-RUN
-INCLUDE APP/mesgtxt
-EXIT
 
Sort by date Sort by votes
FILEDEF cannot be used to concatenate PDF documents. It can be used to concatenate flat files. The way you're doing it is correct but if there is a performance issue, there are other things to look at. Run each of the reports indevidually and see if there are any causing a problem. Is there enough CPU and memory available? If the reports are going against a relational RDBMS, did you trace the SQL to see if the query is being optimized?
 
Upvote 0 Downvote
Thanks for the info. The reason that the file runs slow is that there are about 25 total other fexes going into it. Each graphpg file has 4-5 graphs in it (all running off of different tables). This could be a cause of the time issue.
Is there a way to put all of the graphs into 1 "graphpg" pdf generating fex and have them start new pages instead of running down and off the bottom of one page? I notice that generating a 5 graph pdf page can take 6-12 seconds (depending on how much cpu is being used at the time). Is this the graph->gif conversion taking up time?

Thanks again for the information so far. I'll keep trying to reduce the time on this.
 
Upvote 0 Downvote
The COMPOUND syntax is what creates the single PDF document. If you want users to see all graphs but each on its own page use POSITION in the stylesheet to place them where you want. As far as performance goes, generating graphs will always increase response time. If you want to see if that's where the bottleneck is, change the GRAPH FILE to TABLE FILE and comment out any graph specfic code. If the response time is still too slow, it's not the graph, it's the code.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jsmith22
  • Locked
  • Question
(FOC012) THE WORD 'FILE' OR THE FILENAME APPEARS TWICE
Replies
0
Views
262
jsmith22
jsmith22
harrisnguyen
  • Locked
  • Question
Pass defined field as the parameter.
Replies
0
Views
270
harrisnguyen
harrisnguyen
ekl0908
  • Locked
  • Question
Can I create a JOIN which uses two different keys depending on a field in the file?
Replies
0
Views
296
ekl0908
ekl0908
ekl0908
  • Locked
  • Question
Is there a maximum length for an index field?
Replies
0
Views
300
ekl0908
ekl0908
jackiev
  • Locked
  • Question
Who is running the report - USERNAME
Replies
2
Views
236
gizzy17
gizzy17

Part and Inventory Search

Sponsor

Back
Top