Has anybody figured out how to quickly/efficiently generate thousands of unique 'customer statements' every month [or something similar] using some sort of scalable method [besides looping on a single machine or two] - like an Azure Web Service that can scale up with demand?
Generating PDFs 'serially' takes forever and uses a lot of resources. We use the exact same RPT file, but have to programmatically run it once for each customer in our database [changing the customer id in the parameter]. Is there a better way, I mean doing the looping works but pegs the CPU and takes forever.
I would want to do it in Azure, but I don't think the Crystal dlls can be referenced from an Azure web service, can it? Can referencing the runtime dlls and adding them to the bin folder of the web service - on a machine where the runtime installer has not been run, work? Has anybody done that? It would let me load balance and scale it up.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.