We have a database based list with over 15,000 members and the performance is fine. Obviously, the performance will depend on the capability of your database. Melissa ----- Reply message ----- From: "Sheree Englehardt" <[log in to unmask]> Date: Tue, Sep 14, 2010 10:14 am Subject: [LSTSRV-L] Benefits for Against using ODBC To: "[log in to unmask]" <[log in to unmask]> I wonder what if performance would be an issue with an ODBC interface when creating dynamic lists? Some of our lists are very large, i.e. over 4000 members. Perhaps it would not be practical to create dynamic lists of this size? __________________________ 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 Paul Russell Sent: Monday, September 13, 2010 5:54 PM To: [log in to unmask] Subject: Re: Benefits for Against using ODBC On 9/13/2010 17:41, Valdis Kletnieks wrote: > On Mon, 13 Sep 2010 16:57:12 EDT, Sheree Englehardt said: >> 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. > > What would be the point of an ODBC interface if it didn't allow you to do this > sort of thing? :) > > Yes, it's possible - but as we've not deployed it locally yet, somebody else > will need to fill in the details. > See http://www.lsoft.com/manuals/15.5/htmlhelp/advanced%20topics/DBMSandMailMergeSupport.6.1.html#2340739 -- Paul Russell, Senior Systems Administrator OIT Messaging Services Team University of Notre Dame