database - Space efficient marketing email storage -
i'm working on mail gateway automatically provide (among other things) "view in browser" functionality emails being sent through it. raises need store emails somewhere can accessed. though time period limited, , applying gzip before saving message, we're looking @ ~500gb of storage required keep recent messages.
since emails identical (except few personal variables), thinking if there more efficient way store. deduplicates stuff across multiple records, or that. suggestions on that?
alternate way save template, , save variables each email sent, don't want that, process should transparent sender. means information not accessible, , needs deduced after fact.
this should done dynamically. store email once existed before added subscriber specific content/merge tags (variables). in email need have 'view in browser' link unique each subscriber. based on link serve unique variables in browser based version.
if there lot of unique content, might want use database, otherwise if name example, pass url parameter itself.
Comments
Post a Comment