Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Filedef the big guys

Filedef the big guys

Filedef the big guys

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.

EX APP/prog1
EX app/prog2
EX APP/prog3
EX APP/graphpg1
EX app/graphpg2
EX app/graphpg3
-INCLUDE APP/mesgtxt

RE: Filedef the big guys

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?

RE: Filedef the big guys

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.

RE: Filedef the big guys

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close