I understand that for performance purposes in my case it will be better to download the data rather than accessing it through the public API. On a practical note I am only interested in a subset of the FAERS reports, for example, only those reports that have Alzheimers disease as an indication or key word. Is that possible.
Unfortunately, openFDA does not currently offer a capability to produce "filtered" downloads. Your best bet would be downloading the entire dataset and then processing JSON locally.