cfprint and cfdocument resource from a database runs slow

145 views Asked by At

I have been having issues printing a cfdocument variable with cfprint. The printing works but it takes a lot of time before running. Please, what can be the cause.

PS: I'm fetching some data from my database.

The code is nothing more than in this format

<cfquery datasource="xxx" name="fg">
    SELECT *
    FROM table
    WHERE 1 = 1
</cfquery>

<cfdocument name="print_pdf" format="pdf" localUrl="true">
    I did some little outputting of the query here e.g 

     <cfoutput query="fg">
        #column1#<br>
        #column2# * #column3#<br>

</cfdocument>

<cfprint source="print_pdf" printer="PRINTER NAME">

But when i load this page it takes while. really long before loading completely. Is there anything i'm doing wrong or any way to optimize the work?

0

There are 0 answers