I'd like to hear opinions on how to implement this: I have a database of
users and I'd like to have a section for "alerts" or "internal messages".
This would store messages/alerts send by another user (a request, a
response, etc.), or by the system (new message, new request, new
contribution to discussion thread, etc.).
What I'd like to know is how would you go about those storing alerts:
- A bunch of fields in the user database, like "alert1" through "alert
100"? In that case, what happens when there are more than 100 alerts
accumulated? And, wouldn't that make a huge database?
- Some system (that I don't know of) that would add a field to the database
as alerts come in, thus allowing for an infinite number alerts?
- Something else?
The way eBay does it is they let you keep up to 30 items in your
"monitoring auction" section, and you cannot add any more when you reach
that limit. So I guess in their case they do have 30 fields in the user
database. That, as said before, would be kind of limiting.
Any ideas, best practices, possible solutions that you can think of or have
actually implemented?
Thanks in advance,
Roberto Perez
[EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
