PLSQLDoc With large number of Objects

[jpyman]

Plsqldoc works very well when I only have a few html documents in my destination directory (less than 10). Much more than that, and the generation of new documents becomes incredibly slow. Some documents which were taking 20 seconds or so to generate, now take over 5 minutes each.

We have worked around it by generating the documents in an empty directory and then copying them across to a central repository. The problem with this is that with several developers, people sometimes forget to copy the new documentation, the generation process is forgotten, etc and things are rapidly getting out of sync. If speed wasn't an issue, we could regenerate the more volatile documentation easily on a regular basis.

Is anyone else experiencing similar issues? Can anyone think of a better workaround?

 

[Marco Kalter]

Thee questions:
Are you using the latest 1.2 version?
What is the setting of the "Search cross-references" option?
Is it slow for the first generation, or also for subsequent generations?

 

[jasonvogel]

This is that same issue that I've told you about. It becomes incredibly slow once there are several Html pages generated. The cross-reference update is for the "other" pages performs really poorly, when it should be really quick.

And I have the latest PL/SQL Doc and Dev.

Jason

 

[jpyman]

Marco,

I am using the latest 1.2 version, and I have tried all the "Search cross-references" options. Even when set to "none", it doesn't seem to improve the speed at all.

Based on Jason's description, it sounds like we are experiencing the same issue.

Jeremy

 

[jasonvogel]

I see performance issues with only 1 page even. If I create a new, single page, it is takes a second or two. I compile and re-build the PL/SQL Doc, the REBUILD can take upwards of a minute or more.

Jason

 

[jpyman]

Now that you mention it, that seems to be a better description of what is happening to me too.

I tired rebuilding one package this morning with none on the search cross references option to test Marco's suggestion. In a directory with no other html pages it took a minute or two. Creating a new one only took a matter of seconds.

When doing the same thing in our central repository, it took 11 minutes to generate a new document for the same package. When rebuilding the package, I ended up killing the job after 35 minutes.

 

[Marco Kalter]

We will investigate this. We do indeed have the same problem report from Jason.