Hi Alan, Is there not a command that allows you to switch. I seem to remember somethingt like Use Local but could not find it
Regards Chuck On Wed, Dec 13, 2017 at 1:12 PM, Alan Tilson via 4D_Tech < [email protected]> wrote: > 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 < > [email protected]> 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 < > > [email protected]> 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:[email protected] > > ********************************************************************** > ********************************************************************** > 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:[email protected] > ********************************************************************** > -- ----------------------------------------------------------------------------------------- Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server 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. ********************************************************************** 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:[email protected] **********************************************************************
