Bob, the data which is returned by MySQL server is how much in size/lines/items per line?
Do you use an ip address or the hostname in the connections settings for your MySQL Server? Is it possible, that IP6 is enabled on your Windows machine? If so, did you try to disable it or is IP6 needed? I am running an LC standalone under Win10 64bit in a HyperV VM which connects to MSSQL server using ODBC to fetch 5 price lists. The returned data per price list is about 800kb and contains about 3000 lines with 16 items per line. The standalone fetches the 5 different price lists one after the other, which means it fetches 5 times that amount of data described above. It takes here between 4 and 7 seconds to fetch all 5 price lists although AV + Firewall (F-Secure Client Security) is enabled. - Matthias Rebbe Life Is Too Short For Boring Code > Am 16.03.2020 um 22:11 schrieb Bob Sneidar via use-livecode > <use-livecode@lists.runrev.com>: > > I tried with 3 different computers, all came back with the same times. 2 were > VMs, Parallels and VMWare, and the third was a standalone workstation with AV > disabled. It was also the server that mySQL is running on. :-) > > Bob S > >> On Mar 16, 2020, at 12:37 , Mark Wieder via use-livecode >> <use-livecode@lists.runrev.com> wrote: >> >> On 3/16/20 11:37 AM, Paul Dupuis via use-livecode wrote: >> >>> Most time my Windows 10 laptop slows LC (IDE or SA) down it is due to some >>> other process chewing up time. This is Off Topic, but does any know of a >>> safe, reliable tool that will look at all the processes you see when you >>> bring up the Task Manager and help you figure out what you really and need >>> and what you don't? >> >> Yep - Project Lasso... >> >> https://bitsum.com/ >> >> -- >> Mark Wieder >> ahsoftw...@gmail.com >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
