I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data.
Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook At 09:56 PM 7/26/02 -0700, you wrote: >How bout > ><cfif variables.choiceValue> > <!--- process stuff- --> ></cfif> > >At 11:34 PM 7/26/02 -0500, you wrote: > >I have an if statement that I need to write, it is I am sure very simple, > >but for some reason i cannot think straight on it. > > > >Basically if this variable is a 0 or a "" then I don't want to process > >some stuff ... how would I write this? > > > >This code below doesn't work .. it still lets "" or 0's through... > ><cfif (variables.choiceValue neq "0") OR (Len(variables.choiceValue)> > > > ></cfif> > > > >What am I not thinking of?! > > > >Paul Giesenhagen > >QuillDesign > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
