Looking for insight on subscription based script
View Single Post
10-26-2009, 05:49 PM
is cute and cuddly
Join Date: Mar 2008
Location: Vegas, Baby
I would think it might be more efficient to add a single column to your posts table, 'subscribed' or what have you, and store a serialized array in said column of subscribed user IDs. Then when a new post is submitted, trigger a callback which will run against this array and fire off the necessary emails.
View Public Profile
Send a private message to delayedinsanity
Visit delayedinsanity's homepage!
Find More Posts by delayedinsanity