in reply to Optimizing report generation

Also, large amounts of binary data(the PDFs) are best stored in files and not databases. While it might be handy, it can be rather slow, so you might want to try file-based storage.

~Thomas~
confess( "I offer no guarantees on my code." );