Hello Chuck, You are probably right. I just counted 14 logins to the SQL Server in 1 min 50 sec so I ran a test logging in and out 20 times and this took 2.03 seconds. There would have to be some overhead associated with using a separate process so I doubt there would be any gain. It just seems rather clunky to have to login in and out and to not just be able to specify which source to use or even to be able to use both simultaneously like Access can do! Thanks, Alan
On Wed, Dec 13, 2017 at 12:46 PM, Chuck Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have not but it seems to me to be a lot of work as you will have to get > data/orrays/variables between processes and it would also seem to me that > you could choose only one to put in a new process > > Regards > > Chuck > > ------------------------------------------------------------ > ------------------------------------ > Chuck Miller Voice: (617) 739-0306 > Informed Solutions, Inc. Fax: (617) 232-1064 > mailto:cjmiller<AT SIGN>informed-solutions.com > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D and Sybase connectivity > http://www.informed-solutions.com > ------------------------------------------------------------ > ------------------------------------ > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption from > disclosure as to this communication. > > > On Dec 13, 2017, at 12:28 PM, Alan Tilson via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Hello everyone, > > > > I find myself switching data sources frequently (20 or more times in a > few > > minutes-I'll count the number...) back and forth between 4D and my > client's > > MS SQL Server based system. So today I've been contemplating the idea > that > > I might put all my 4D SQL code in a separate process so that my each > > process could stay logged into either 4D/Local or the SQL Server. > > > > Has anyone tried this? If so, please share your thoughts on the benefits > > and complications and even solutions that this approach offers! > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
