Generate PDFs outside of the CMS
Generating PDFs on-the-fly uses enormous amounts of CPU and RAM. Consequently, do not generate PDFs to order, page by page, but instead offer a few files generated and optimized outside of the CMS
Limit the number of results
When possible, use the LIMIT statement to specify the number of results to return. This helps minimize the amount of CPU and RAM used to find the relevant records.
The improvement in performance will be even greater if the records contain many large fields.








