So what are you saying? You can dynamically build lists from an external database such as SQL Server? I did not think that was possible. But if it is, then I am very interested in knowing more. Thanks. __________________________ Sheree Englehardt Software Developer St. Leo University (352) 588-7590 -----Original Message----- From: LISTSERV give-and-take forum [mailto:[log in to unmask]] On Behalf Of Valdis Kletnieks Sent: Monday, September 13, 2010 12:17 PM To: [log in to unmask] Subject: Re: Benefits for Against using ODBC On Mon, 13 Sep 2010 11:14:22 EDT, Glenn said: > I am new to Listsrv but if I read things correctly there is a performance > hit to using a backend DBMS for your lists. Can someone discuss or outline > the cost/benfits with using a DBMS rather than the listsrv propriatary > setup (hope i said this right). If your data is already in the DBMS (think systems like Banner, PeopleSoft, SAP, etc), it sure is easier to say "mail to everybody in the DBMS who currently status X", rather than having to run an extract job and populate the list and then send the mail, then repeating the extract for the next mail in case somebody's status changed in the interim. I'd certainly like to deploy it for all the "class of 2014" lists and "all chem undergrad majors" and similar lists, it would save me a chunk of work every semester. (I haven't yet due to internal issues that have to get resolved first).