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.