This is not a question for the HoF system but instead one that I'm passing along.
Here's the problem. We have 4000 users getting email during the day and each email is generated from a complex search that checks on about 300 events in a day. Each email is unique and is based on one or more searches that are specific to each user. No user has the same search criteria. Additionally, this data is real time with a single digest a day for users. This is rather stressful on the server and a solution is needed. Additionally, we're dealing with a legacy DB system with 10 tables of 200 total columns joined together (don't ask). I've suggested having a second machine with its own SQL server. This server will receive a replicated feed from the main DB and be used only to generate these emails. Is there a better way to do this? A better solution? Thanks p.s. SQL 2000 pro ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://affiliates.macromedia.com/t.asp?id=2439&p=go/dr_text_aff1 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1710 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
