LSTOWN-L Archives

LISTSERV List Owners' Forum

LSTOWN-L

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Francoise Becker <[log in to unmask]>
Fri, 16 Sep 2005 15:59:20 -0400
text/plain (19 lines)
On 16 Sep 2005 at 10:54, Paul Russell <[log in to unmask]> wrote:

> LISTSERV requires write access to a
> table which has one column per list. We create nearly 8000 course-related lists
> and over 4000 other administrative lists each semester. In this environment, the
> "one column per list" restriction simply does not scale.

You can also have one table per list or several tables, each with 
several lists. I'll agree that it does not provide complete 
flexibility, and your LISTSERV database will not be in 4th normal 
form, but if you use a DBMS that has good support for database 
triggers, you should be able to achieve something that works fairly 
well.

-- 
Francoise Becker <[log in to unmask]>

Knowledge is just a click away: http://www.lsoft.com/optin.html

ATOM RSS1 RSS2